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.
Answers
-
Never mind. The week number is correct.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 34 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!