count specific days within date range

Hi All,

I have a date range like :

A9 (start Date) = 12-01-2012
A10 (end Date) = 08-03-2012


And i need to divide this up into 2 groups Summer and Winter

Summer runs from 01-MAR to 31-OCT each year
Winter runs from 01-NOV to 28/29-FEB each year


So with the example above i need it to divide the 57 total days up as

8 days in summer
49 days in winter

I need this to work no matter what year - can anyone please suggest how i can go about this please ?

Edit : This can be 2 individual formulas - i dont necessarily need them as one

Thanks in advance

Saz

As your periods are entire months you could use a variation on Bob's approach to count dates in months, e.g. for Winter days

=SUMPRODUCT((MONTH(ROW(INDIRECT(A9&":"&A10)))={1,2,11,12})+0)

and then, of course all the other days are in the Summer so if you have that formula in A11 you can use this formula to get the total of the Summer days

=A10-A9+1-A11

This approach will work even if your date range is spread across several years