Calculating overlapping time periods
 

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?

Thank a million!

Calculating overlapping time periods
 

Arlette

You have answers in MOST of your previous posts. Are you looking for one
you like? Please try to stay in the same thread.

Mike Rogers

"Arlette" wrote:

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?

Thank a million!