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.