Thread: Date validation
View Single Post
  #2   Report Post  
Bob Phillips
 
Posts: n/a
Default

Use data validation with a custom formula of

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

--

HTH

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


"patam" wrote in
message ...

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


--
patam
------------------------------------------------------------------------
patam's Profile:

http://www.excelforum.com/member.php...fo&userid=3192
View this thread: http://www.excelforum.com/showthread...hreadid=401481