Calculating number of days in each month during a given period.

Hi Jason,

It works!!! Thanks very very much for your help....

Josnah...

You could probably simplify that formula a little....in B6 copied down

=IF(OR(A5>=B$2,A6<A$2),0,MIN(A6,B$2)-MAX(A5,A$2))

That's makes its look so simple! Never could have thought of it...

Thanks alot for your help!