View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
phocused phocused is offline
external usenet poster
 
Posts: 37
Default Calcualtion days in month from 2 dates

I have a start date and an end date, what I would like to do is to use these
2 dates to calculate the number of days per month. So for example
Start Date: 23/03/06
End Date: 19/05/06
What I want to do is to work out how many days this is in March, April, May
respectively.

So I will end up with a column total for march of 8days, april 30days,
may19days.

any help would be gratefully accepted