Date validation

P

patam

I need to make sure that the date entered in column B is equal to o
greater than column A and that no date can be entered in "b" if "a" i
blan
 
B

Bob Phillips

Use data validation with a custom formula of

=AND(A2<>"", B2>=A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

Ray A

RD
Uncheck the ignore blank box then it worked for me
HTH

RagDyeR said:
Doesn't work for me Bob, and I'll be darned ... I can't figure out why or
what else to use?!?!

*Can't* stop B from accepting input when A is blank.

Does it work on your box?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Use data validation with a custom formula of

=AND(A2<>"", B2>=A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
R

RagDyer

I'm really wondering what you were thinking when you posted the above
(nothing).<g>

You do realize that I would not have made a fool of myself if the responder
would have properly instructed the OP to uncheck the "ignore blank"
box.<gdr>
 
B

Bob Phillips

That was what I was thinking but I was so shocked I couldn't get the words
out. My hands were shaking so much, the keys didn't respond <vbg>

I apologise unreservedly, for my omission and fully accept liability, and
promise to remember to tell everything next time (I have just completed a 12
page answer on adding time for example <ebg>).

Bob


RagDyer said:
I'm really wondering what you were thinking when you posted the above
(nothing).<g>

You do realize that I would not have made a fool of myself if the responder
would have properly instructed the OP to uncheck the "ignore blank"
box.<gdr>
--
Regards,

RD

-------------------------------------------------------------------------- -
Please keep all correspondence within the NewsGroup, so all may benefit !
-------------------------------------------------------------------------- -

Bob Phillips said:
--

HTH

RP
(remove nothere from the email address if mailing direct)


why
or
Click to expand...
"a"
Click to expand...
 
R

RagDyeR

Doesn't work for me Bob, and I'll be darned ... I can't figure out why or
what else to use?!?!

*Can't* stop B from accepting input when A is blank.

Does it work on your box?
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

Use data validation with a custom formula of

=AND(A2<>"", B2>=A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
R

RagDyeR

Duhhhh !!! <g>


RD
Uncheck the ignore blank box then it worked for me
HTH

RagDyeR said:
Doesn't work for me Bob, and I'll be darned ... I can't figure out why or
what else to use?!?!

*Can't* stop B from accepting input when A is blank.

Does it work on your box?
--

Regards,

RD
-------------------------------------------------------------------------- --
-------------------
Please keep all correspondence within the Group, so all may benefit !
-------------------------------------------------------------------------- --
-------------------

Use data validation with a custom formula of

=AND(A2<>"", B2>=A2)

--

HTH

RP
(remove nothere from the email address if mailing direct)
Click to expand...
 
Top