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.

Thanks.

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:

    =ROUNDUP((WEEKDAY(DATE(YEAR(TODAY()), MONTH(TODAY()), 1)) + DAY(TODAY())) / 7)

«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!