Calculate the week number of current date within a month

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi All,

Is it possible to calculate the current week number within a month? I know that

add(div(dayOfYear(utcNow()),7),1) returns the week number within a year. What I want to know is how to return the week number within the month. For instance todays date 15th november should return Weeknumber = 2 since it is the second week of november.

Please let me know if there is a solution to get this.

Thanks

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

mahoneypat 1,720 on at

Like (0)

Report
Copy link

Link copied!

Please try this expression

formatNumber(div(dayOfMonth(utcNow()),7), '0')

Pat

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @Anonymous,

Do you want to get the week number of today?

You just need to modify your formula as below:

add(div(dayOfMonth(utcNow()),7),1)

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

This worked. Thankyou!

Was this reply helpful? Yes No