I'm guessing you have a table that will reference each month's pay
increase. You can use the =month(A1) where A1 is a date. That will
give you numbers 1 through 12 based on the date. You can build this
into the if statements that reference your rate table (or however you
have it designed).
Hope it helps.
Phillycheese
--
Phillycheese5
------------------------------------------------------------------------
Phillycheese5's Profile:
http://www.excelforum.com/member.php...o&userid=24196
View this thread:
http://www.excelforum.com/showthread...hreadid=477913