| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sequence of Weeks in a month
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you calculate the number of weeks on a month | Excel Discussion (Misc queries) | |||
| Sum data for weeks in a month | Excel Discussion (Misc queries) | |||
| sort by month out of sequence | Excel Discussion (Misc queries) | |||
| how do I automatically sequence the month | Excel Worksheet Functions | |||
| Archiving 4 weeks of data into Month folders | Excel Discussion (Misc queries) | |||
![Elton Law[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
