Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for reading this post.
In column A I would like to enter dates. For instance the date entered in A5 should be verified for the following. Question :- 1 If A4 is blank, no entry should be permitted in A5 2 If A4 is not blank, then A5 could be equal to or greater than A4 Alternate :- 1 If A4 is blank, no entry should be permitted in A5 2 If A4 is not blank, then A5 should be equal to TODAY( ) What should be the CUSTOM/FORMULA for both the above validations? Thanks in advance Regards Preman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DATE VALIDATION | Excel Discussion (Misc queries) | |||
date validation | Excel Worksheet Functions | |||
Date Validation | Excel Worksheet Functions | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Date validation | Excel Discussion (Misc queries) |