Salary by Qtr Formula
 

I'm trying to calculate by quarter how much an employee will cost depending
on when they are hired. I have a column for 4Q09 (Col R4), 1Q10 (Col S4),
2Q10 (Col T4), 3Q10 (Col U4) & 4Q10 (Col V4) and will need a formula for
each. In cell M4 the date is plugged in. In cell Q4 a weekly rate is
already entered in this case $573. Above in cells R1-V1 I have put dates
12/31/09, 3/31/10, 6/30/10, 9/30/10, 12/31/10.

The formula below that I'm using only works if M4 has a date in 2010, I need
it to work for 2009 as well. I'm not sure if this formula can be modified to
do that or if another formula is needed.

=IF($F4="On Board",MAX(0,((S$1-$M4)/7))*Q4,"")

S1 = 3/31/2010
M4 = 10/15/2009
Q4 = Weekly Salary $573

Thank you very much for your help!

Salary by Qtr Formula
 

The formula below works for 2009 as well. Is the cell in M4 showing as actual
date or text? May want to clear out the format and type in the date...

"KC" wrote:

I'm trying to calculate by quarter how much an employee will cost depending
on when they are hired. I have a column for 4Q09 (Col R4), 1Q10 (Col S4),
2Q10 (Col T4), 3Q10 (Col U4) & 4Q10 (Col V4) and will need a formula for
each. In cell M4 the date is plugged in. In cell Q4 a weekly rate is
already entered in this case $573. Above in cells R1-V1 I have put dates
12/31/09, 3/31/10, 6/30/10, 9/30/10, 12/31/10.

The formula below that I'm using only works if M4 has a date in 2010, I need
it to work for 2009 as well. I'm not sure if this formula can be modified to
do that or if another formula is needed.

=IF($F4="On Board",MAX(0,((S$1-$M4)/7))*Q4,"")

S1 = 3/31/2010
M4 = 10/15/2009
Q4 = Weekly Salary $573

Thank you very much for your help!