Skip to main content

Notifications

Community site session details
Power Automate - Building Flows
Answered

Calculate the week number of current date within a month

Like (0) ShareShare
ReportReport
Posted on 15 Nov 2021 14:48:03 by

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
  • Verified answer
    v-qiaqi@microsoft.com Profile Picture
    on 16 Nov 2021 at 09:53:33
    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)

    vqiaqimsft_0-1637056379782.png

     

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 196 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 181 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 169

Overall leaderboard
Loading started
Loading started