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

Dennis Jolley

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.

Dennis Jolley

Never mind. The week number is correct.