If hired before a particular date

**Kimston** · 11-04-2011, 10:26 AM

Can someone help me develop a formula that can look at a column C, and if date is less than 10/1/2001, then give a yearly increase of $.44 in column F. On the other hand, if an employee was hire after October 2001, then give a yearly increase of $.20. See attachment for more details.
Thank you for all your help and dedication.

**brokenbiscuits** · 11-04-2011, 10:34 AM

See attached

**milleribsen** · 11-04-2011, 01:43 PM

If I understand you correctly I believe this should work:

IF(C2<37165,F2+0.44,F2+0.2)

This is assuming that the information is in row 2, and you only need one year increase. The number 37165 is the excel number for the date you provided.

**Kimston** · 11-04-2011, 02:48 PM

Brokenbiscuits,
I want to thank you for responding to my post promptly and for sharing your knowledge and helping me to solve this problem that I face every time I have to work with this project.