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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives