Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validating Dates Entered
How can I set this up? If Column A is blank then no date can be added to Column B; If there is a date in Column A then Column B must be equal to or greater (=) than Column A Seems like it should be easy enough but I can't get it to work. Thanks! -- patam ------------------------------------------------------------------------ patam's Profile: http://www.excelforum.com/member.php...fo&userid=3192 View this thread: http://www.excelforum.com/showthread...hreadid=401502 |
#2
|
|||
|
|||
Select Cell B1 On Menu Bar, select Data Validation Settings: Allow Custom Ignore Blank not checked Formula should be =AND(A1<"",B1A1) -- DCSwearingen ------------------------------------------------------------------------ DCSwearingen's Profile: http://www.excelforum.com/member.php...o&userid=21506 View this thread: http://www.excelforum.com/showthread...hreadid=401502 |
#3
|
|||
|
|||
One way:
Data/Validation/ Allow Custom: =AND(A1<"",B1=A1) uncheck the Ignore blank checkbox. In article , patam wrote: How can I set this up? If Column A is blank then no date can be added to Column B; If there is a date in Column A then Column B must be equal to or greater (=) than Column A Seems like it should be easy enough but I can't get it to work. Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing dates entered in 2005 to previous years | Excel Worksheet Functions | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
have dates entered from a list of data into an excel template | Excel Discussion (Misc queries) | |||
micosoft excel dates entered but changed to sequencial numbers ho. | Excel Worksheet Functions | |||
If both dates are entered into a cell then answer is yes | Excel Worksheet Functions |