| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Days in a specific month
Hi all,
I hve noted there are documented ways to calculate the number of weekdays in any month, but my enquiry is somewhat different. I have 5000 rows, with two columns [actual_start] and [actual_end] for my date ranges, which invariably stay within a calendar month. Easy enough to calculate the number of weekdays between the two dates ( NETWORKDAYS() ). But, if the two dates go between say 27-Aug-09 and 3-Oct-09, I only want to know the number of weekdays in September. is this possible, and can anyone advise? TIA Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of days in a specific month between various start and end d | Excel Worksheet Functions | |||
| excel to make the days cary over month to month automaticly | New Users to Excel | |||
| Calc Prorated Cost based on Specific Days in a Given Month & Year Range (Revisited..) | Excel Discussion (Misc queries) | |||
| Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
| Days per month for calculating storage days | Excel Worksheet Functions | |||
Threaded Mode
