#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 119
Default DATE DATA VALIDATION

Coumn A has dates and blank cells.
Coumn B has dates.

Is it possible to specify that a date entered into column A must be later
than a date in Column B? A problem arises when a cell in column A is blank,
because excel reads this as 0 and therefore ANY date in the corresponding
cell in column B is going to be perceived by excel as later and therefore not
valid. So, in other words, what I want is a to specify that if there is a
date in column A AND a date in column B, excel will accept only a date in
column B later than the date in column A. But if column A is blank, then
Column B will accept any date.

Thanks for assistance.
--
William
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 208
Default DATE DATA VALIDATION

In Data- Validation

Select custom enter this formula (starting in row 1 or change the 1 to
whatever row you want to start with):
=IF(ISBLANK($A1),TRUE,IF($B1$A1,TRUE,FALSE))
uncheck ignore blank.

hit ok




On Aug 8, 8:53*am, William wrote:
Coumn A has dates and blank cells.
Coumn B has dates.

Is it possible to specify that a date entered into column A must be later
than a date in Column B? *A problem arises when a cell in column A is blank,
because excel reads this as 0 and therefore ANY date in the corresponding
cell in column B is going to be perceived by excel as later and therefore not
valid. *So, in other words, what I want is a to specify that if there is a
date in column A AND a date in column B, excel will accept only a date in
column B later than the date in column A. *But if column A is blank, then
Column B will accept any date.

Thanks for assistance.
--
William


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to set data validation on cell that display a date in Excel? SBA22000 Excel Worksheet Functions 2 July 4th 08 09:48 PM
Data validation: want input restricted to date value or N/A Rachel Garrett Excel Worksheet Functions 2 June 11th 08 07:37 PM
Data Validation for a date mgkaam Excel Discussion (Misc queries) 9 January 25th 07 09:44 AM
Data Validation with Blank Date Gos-C Excel Worksheet Functions 2 August 4th 06 01:02 PM
Conditional End Date in Data Validation Settings Gos-C Excel Worksheet Functions 6 April 28th 06 01:49 AM


All times are GMT +1. The time now is 02:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"