View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Maverick_TG Maverick_TG is offline
external usenet poster
 
Posts: 4
Default '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