Month from Week Number
The data source I have is only providing WeekNumber of a transaction, e.g. 1 - 52.
Is there a way to convert that week number into the respective month number, 1 - 12?
I can think of a painful nested if formula or an equally painful reference table as solutions.
But can anyone think of an easier formula?
Tags:
Answers
-
Hi, Casey.
Let's say the year is 2022 and is in the column Start Year, and the week number is 23.
= MONTH( DATE([Start Year]@row, 1, 1) + ([Week Number]@row * 7))
01/01/2022 + (23 * 7) = 06/11/2022 ; Month = 6 ; June if you do some tweaking.
Cheers!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.2K Get Help
- 361 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 444 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives