View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Bernie is offline
external usenet poster
 
Posts: 47
Default Occurences between 2 dates

I have a start and end date on one sheet, another sheet with a list of dates
in the month.
I need to know how many instances the item was active on a given date
such as
1/1/09 - 5
1/3/09 - 4
1/6/09 - 1
Start End
1/1/2009 1/2/2009
1/1/2009 1/3/2009
1/1/2009 1/6/2009
1/1/2009 1/5/2009
1/1/2009 1/3/2009

Thanks Bernie