| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
WeekDay count between dates
I have a number of records and each has a field of start and end dates. What
I need to work out is how I can count for each day of the week, how many days are included in this date range (excluding the last date). i.e. Start: 01/04/2008 End: 12/04/2008. Monday = 1 Tuesday = 2 Wednesday = 2 Thursday = 2 Friday = 2 Saturday = 1 Sunday = 1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| prompt for weekday and distribute the dates in columns | Excel Discussion (Misc queries) | |||
| count weekday()=1 | Excel Worksheet Functions | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| How can I calculate dates and skip a specific weekday? | Excel Discussion (Misc queries) | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Threaded Mode
