DATE VALIDATION
 

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

DATE VALIDATION
 

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

DATE VALIDATION
 

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

DATE VALIDATION
 

*sigh*
--
John C


"John C" wrote:

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

DATE VALIDATION
 

Thanks, all, for your excellent help.
--
William


"David Biddulph" wrote:

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