DATE VALIDATION

[William]

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?

 

[John C]

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]

*sigh*
--
John C

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.

 

[William]

Thanks, all, for your excellent help.