Excel Formula to calculate 90 days after hire date & Add Initial Pay Rate

**Kimston** · 01-25-2012, 04:27 PM

Hi everyone,
I am recurring to you guys again for your help. I am trying to find a formula which adds 90 to a hire date. I am using

Please Login or Register  to view this content.

which gives me a new date after hire date. I don't know if this is correct. Also, I need another formula to add the Initial Pay Rate plus 90 days increase. I would greatly appreciate if there is another formula that can point to A2 (new hire) and if this employee is a new employee, than fill the rest E2 and H2. See attachment for better detais.
Again, Thank you for your help and knowledge.

**Fotis1991** · 01-25-2012, 04:37 PM

Hi Kimston

Maybe... =IF(A2="new hire";D2+90;"")

Or i miss something??

**Kimston** · 01-25-2012, 06:03 PM

Thank you Fotis for your quick response. However, where to I put =IF(A2="new hire";D2+90;"")
I placed it in E2 or H2 but I am getting an error: the formula that you typed contains an error. Should this formula contain commas and not semicolons?

**Fotis1991** · 01-25-2012, 06:16 PM

Hi

Does it helps you?

**Kimston** · 01-25-2012, 06:38 PM

Excellent, Now what I did is to add =F2+G2 in H2 to come up with Pay rate after 90 day. That solved my problem. However is there a formula that I can put in which warns me 5 days before an employee reaches his\her 90 days?
Greatly appreciate

**Fotis1991** · 01-25-2012, 06:59 PM

..So try this in I2

=IF(E2=TODAY()+5;"SOS";"")

Hope to be ok, because for me is bed time now!!!

**Kimston** · 01-25-2012, 07:01 PM

Excellent Fotis. Again I really really appreicate your time. Have a good night and rest! Talk to you soon.

**Fotis1991** · 01-25-2012, 07:05 PM

You are welcome!

Glad to helped you.

What time(and what date) is in Argentina, now??

..And of course if you find your solution,mark your Thread, as SOLVED.

**Charlie_Howell** · 01-25-2012, 09:22 PM

try this in H2 =IF(TODAY()>=E2,F2+G2,"")

**Kimston** · 01-30-2012, 11:05 PM

Guys, I just want to let you know that Fotis1991 and Charlie Howell's responses have helped me a lot on what I want to accomplish. However, I am working on adding more conditions in order to accomplish what I need from these formulas. Please be patient with me. By the way Fotis, here in Argentina is Monday the 30th and it's 11:57 pm.
Again, thank you very much. I'll get back to you tomorrow.