Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
'08-'11 Days of the Wk per Month
I have an array of date ranges from 2008-2011 and would like to
calculate how many "Mondays" per month take place within this range. For example, range #1 6/29/09 - 8/16/09 consists of 7 weeks over 3 months. Is there a way I may seperate the # of weeks per month, June - 1 "Monday", July - 4 "Mondays", August - 2 "Mondays" (1 + 4 + 2 = 7) As there is 500+ various date ranges, any assistance would be appreciative. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
excel to make the days cary over month to month automaticly | New Users to Excel | |||
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 | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
function to fill all days of month to end of month | Excel Worksheet Functions |