in cell B2, menu Data|Validation
Allow: Date
Data: Less than or equal to
End Date: =DATE(YEAR(A2)+3,MONTH(A2),DAY(A2))
Highlight cells B2 through B??? (however far down as needed), Choose
Data|Validation, and OK.

--
John C


"William" wrote:

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