How to count current week for the month?
Answers
-
@PeggyLang I understand what you are saying. That you think it should be week 1 of August. But since you are calculating on Monday, Monday's date is technically the 5th Monday in July. What would you expect it to output next week?
-
@Paul Newcome Next Monday would be WK2 of 8th month
-
@PeggyLang Just to be sure I understand what you are looking for… Whatever week the first of the month falls in is considered the first week of the month regardless of what day of the week it is?
-
@Paul Newcome Correct
-
@PeggyLang Give this a try…
=WEEKNUMBER(IF(MONTH(Date@row) <> MONTH(Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6), Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6, Date@row)) - WEEKNUMBER(DATE(YEAR(IF(MONTH(Date@row) <> MONTH(Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6), Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6, Date@row)), MONTH(IF(MONTH(Date@row) <> MONTH(Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6), Date@row + (2 - WEEKDAY(Date@row)) - IF(WEEKDAY(Date@row) < 2, 7, 0) + 6, Date@row)), 1)) + 1
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 367 Global Discussions
- 202 Industry Talk
- 432 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 285 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!