WEEKNUMBER formula not returning correct result

Options

When I use the formula for WEEKNUMBER, my results are being offset by 1 week between Sunday and Monday.

Sunday, Sept. 12 = Week 36 (Correct)

Monday, Sept 13 = Week 37 (Incorrect)

I have checked my project settings, set my working days, etc., but I cannot figure out why this formula will not return the correct week number for Monday.


Can anyone give an advice? Thank you

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!