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