I think that that original expression was mdy, though. (well, if I can trust
that all were like 9/30/2005.)

Bob Phillips wrote:

ANother way

=--"2006-01-01"+(A5--"2005-09-30")

--

HTH

RP
(remove nothere from the email address if mailing direct)

"Simone" wrote in message
...
I need use the if function to do the following:
if the hire date is greater than 9/30/2005, then the date should be
2/1/2006, otherwise the date should be 1/1/2006.

I have been using the following, if(A59/30/2005, 2/1/2006, 1/1/2006), but
it changes every date to 1/1/2006 including dates greater than 9/30/2005.

Please help!

--

Dave Peterson