Hi James
Assuming you have the Analysis Toolpak loaded (ToolsAddinsAnalysis
Toolpak), then you can use the Eomonth() function.
With Start date in A1, End Date in B1
days in May =EOMONTH(A1,0)-A1+1
days in June =B1-EOMONTH(A1,0)

Format the cells containing the formula as General.
Both formulae assume that you are counting the whole of the start date
and the whole of the end date
--
Regards

Roger Govier


"jamesjohn"
wrote in message
...

How can I separate days into different months and count them ?

If I have a date of arrival and a date of departu

17/05/2006 to 22/06/2006

how can I count the numberof days in May and the number of days in
June
and have them separated ?

Thanks in advance.


--
jamesjohn
------------------------------------------------------------------------
jamesjohn's Profile:
http://www.excelforum.com/member.php...fo&userid=9692
View this thread:
http://www.excelforum.com/showthread...hreadid=545300