Is anyone getting the wrong week number when using Weeknumber formula?


I am referencing the date of each entry and using the date number to trend data. The formula is =WEEKNUMBER([Inspection Date]@row), where Inspection Date is a date field. For today's date, 4/28/2021, it is returning week 17 - however, in Excel, it returns week 18.

To further test, I augmented the weeknumber formula to, =WEEKNUMBER(TODAY()) and it returns week 17. The same formula in Excel returns week 18.

Please assist.

Thank you.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!