C1: =DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
D1: =DAY(DATE(YEAR(A1),MONTH(A1)+2,0))
E1: =DAY(DATE(YEAR(A1),MONTH(A1)+3,0))
--

HTH

RP
(remove nothere from the email address if mailing direct)


"STFC" wrote in message
...
Hello,

Hope someone can help.

A1 = Start date B1=End Date eg A1 = 1st Jan B1=4th April

C1=Days in Jan D1=Days in Feb E1=Days in Mar etc until Dec.

Therefore for the above example C1 would = 31days D1 = 28days E1 = 31days
and F1 = 4 days.

I have been playing around with IF and DATEDIF but I'm getting nowhere.
Any
help would be much appreciated.