Hello,
I have a sheet that acts as a "day tracker." Each row is a new date that tracks specific data in each column. I have a "Week Number" column attached to the "date" column, however the week number populated does not match the week number shown in Outlook calendar and Excel. I think this is because Smartsheets starts their week on Monday's and other programs start the week on Sunday's.
Does anyone have a work around for getting the WEEKNUM formula to populate on Sunday's instead of Mondays? I have tried changing the sheet to *Gantt View* and changing the "Start day for the Week" to Sunday but that still does not impact the WEEKNUM formula outcome.
Example:
In Smartsheets:
12/27/20 = Week Number 52
12/28/20 = Week Number 53
In Excel:
12/27/20 = Week Number 53
12/28/28 = Week Number 53