View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
N Harkawat N Harkawat is offline
external usenet poster
 
Posts: 55
Default Calculate days in a month

I have data in columns as follows:

Start date | End date | April | May | June


What I am trying to get is how many days are in each of the column months.
For instance :
Start date - Jan-4-08 End date: April-2-2008
then a formula that will post 2 in column April , 0 in May and 0 in June

15-April-08 to 9th June 2008 will put 15 , 31 , 9 in respective columns
02-June-08 to 09-July-08 will put 0,0,28

thx