How to count the days when the periods overlap

[Nathalie]

I am looking for a formula for the number of days in which to calculate two periods overlap. I need to calculate the following: If C10 (entrance maternity leave) t/m C14 (maternity leave end date falls in the period C19 (last day before the summer holidays) t/m C21 (first day after the summer holiday) than show the number of days that the periods overlap.

For Example: IF C10 t/m C14 falls in C19 t/m C21 than number of days that they overlap. So if 21-06-2012 t/m 11-10-2012 falls in 06-07-2012 t/m 20-08-2012 than 45 days

or

IF 20-01-2012 t/m 11-05-2012 falls in 06-07-2012 t/m 20-07-2012 than 0 days

Can you please help me?

[jason.b75]

Try

=MAX(0,MIN(C14,C21)-MAX(C19,C10))