WEEKNUMBER returning incorrect value?
[Please note dates are in YYYY-MM-DD format as I am in Australia and date column name is TueDate]
-- Ignore last column they are calculated values that I needed to keep in the image so you could see the formula
I have the following sheet, which uses the WEEKNUMBER function to just return the number of the week in the year. The second column uses YEAR(TueDate@row) to return the year.
I am looking at every Tuesday and what week number that is. As it turns out 1/1/2019 is also a Tuesday and that correctly returned WEEKNUMBER=1 for 2019, but for Dec 31, 2019 it also returns WEEKNUMBER=1 for 2019.
At the end of 2020 it (correctly?) returns WEEKNUMBER=53 for Dec 29, 2020
Is this a bug in SmartSheet, Dec 31, 2019 cannot be week 1 for 2019?
Are there any suggested work arounds other than manually changing the values for Dec 31, 2019 and adjusting the following formulas by one?
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Help Article Resources
Check out the Formula Handbook template!