Sequence of Weeks in a month
A1 : 14 May 2009
A2 : 7 May 2009
A3 : 1 May 2009
A4 : 2 May 2009
B1, entered the formula, and filled down
=WEEKNUM(A1)-WEEKNUM(EOMONTH(A1,-1)+1)+1&MID("stndrdthth",(WEEKNUM(A1)-WEEKNUM(EOMONTH(A1,-1)+1)+1)*2-1,2)&" week of "&TEXT(A1,"mmmm")
The result of B1 will return : 3rd week of May
Regards
Bosco
"Elton Law" wrote:
Dear Expert,
Is there any functions that can identify the number and the sequence of week
in a month please ?
Weekday(A1) can only give Mon,Tue, Wed ....
Say today 14 May is the 3rd week of May.
7 May is 2nd week of May.
1 and 2 May are the 1st week of May.
I have used Weekday(A2) - Weekday(A1) to sort out the weekend.
But it is hard to give this is the 1st or 2nd or 3rd or 4th week in that
month.
Hope someone can help
|