What validation formula did you try that it wouldn't accept?

Why not:
DV
Allow: date
Less than or equal to:
=DATE(YEAR(A1)+3,MONTH(A1),DAY(A1))

You could use =A1+1095 if you prefer
--
David Biddulph

"William" wrote in message
...
xp/2003

In column A is a birthdate. A date will also be entered in Column B, but
I
want to prevent entry of a date later than the third birthday. Birth
date
plus 1095 = the third birthday, but I can't find a validation formula that
Excel will accept for column B to bring off what I want.

Can this be done?
--
William