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 a

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


Project Dates a

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? We
would also like to include a formula that will change the dates
automatically when necessary?

Thank a million!