Try changing that to =IF(H8<--"1/1/2007",--"1/1/2007",H8)
--
David Biddulph

"Les Thompson" wrote in message
...
Quotation marks turn the date into text strings. (note the formatting on
the
left of the cell). Cannot do math on text but thank you very much for
your
input. I do appreciate it.

"Gary''s Student" wrote:

=IF(H8<"1/1/2007","1/1/2007",H8)

--
Gary''s Student
gsnu200711