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.

 

[David Biddulph]

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

 

[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.