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