Calculating overlapping time periods

[Arlette]

I would so much appreciate any help with Microsoft Excel in having the
software automatically calculate the number of time periods to apply
for salary cost purposes.


Here is the issue:


Employee Y

Annual Merit increase dates are:

03/01/2007 - 02/28/2008 $100,000
03/01/2008 - 02/28/2009 $105,000


Project Dates are:

07/01/2007 - 6/30/2008


For this project period (07/01/2007 - 6/30/2008), Employee Y's salary
would be

8 months of $100,000 = $66,667
4 months of $105,000 = $35,000
Total $101,667

Have you any idea which formula we could use to calculate this?

Thank a million!