How to count current week for the month?

I need a formula to calculate the week number for the month, for example 28 May 2020 is the 5th week of the month.

I understand that week number calculate from w1 - w52.

How can I calculate the week number for the month? So basically, the answer will be between number 1 - 5.


Best Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    @Vivien Chong

    When I replaced TODAY() in the WEEKNUMBER() - WEEKNUMBER formula with dates (to see what would happen when TODAY() becomes those dates), I actually ended up getting a fair amount of incorrect outputs including some negative numbers.

    I would actually suggest using @L@123's solution of:




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!