Calculate the week number of current date within a month

Like (0) Share

Report

Posted on 15 Nov 2021 14:48:03 by Community Power Pla...

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

I have the same question (0)

All responses (3)

Answers (1)

mahoneypat 1,720 on 15 Nov 2021 at 22:25:58

Like (0)

Report

Re: Calculate the week number of current date within a month

Please try this expression

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

Pat

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com on 16 Nov 2021 at 09:53:33

Like (1)

Report
Re: Calculate the week number of current date within a month

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... on 17 Nov 2021 at 11:18:25

Like (0)

Report

Re: Calculate the week number of current date within a month

This worked. Thankyou!

Was this reply helpful? Yes No