View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Veritec Veritec is offline
external usenet poster
 
Posts: 3
Default Breaking down days between dates

Given two dates (e.g. November 7, 2004 and January 16, 2005) I am trying to
identify how many days are in November, December, and January.

The dates represent meter readings and I am trying to breakdown how much of
the overall consumption can be assigned to each individual month. In the
example above 7 days in November, 31 in December, and 16 in January.

Thanks for your help.