K
KC
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!
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!