| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr
In A1 down are 1st of month real dates formatted as mmm-yy, eg:
Jul-08 Aug-08 etc In B1 down, I would like to extract the number of weekdays (Mon-Fri) and in C1 down, the number of Saturdays for the month/yr listed in col A Eg for Jul-08 in A1, result in B1: 23, in C1: 4 Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Weekdays of the month. | Excel Discussion (Misc queries) | |||
| Need a way to determine the # of Saturdays in a month | Excel Worksheet Functions | |||
| Count # of Saturdays in a month | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
Threaded Mode
