Hi I was hoping someone might make my day with this one.

I am trying to write a formula that calculates the number of days between 2 dates including the start date as a day.

Start: 2 Jan 07
Finish: 18 Feb 07
Result (48 days)

However...I also want it to work out how many of the result days fall into pre determined specified periods.

Period 1. 1 Jan 07 - 15 Jan 07 Result Days = 14
Period 2. 16 Jan 07 - 18 Feb 07 Result Days = 34

Anybody?