How to count current week for the month?

Paul Newcome

@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?

PeggyLang

@Paul Newcome Next Monday would be WK2 of 8th month

Paul Newcome

@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?

PeggyLang

@Paul Newcome Correct

Paul Newcome

@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