Salary by Qtr Formula

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!
 
S

Sean Timmons

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top