karabiner8
Board Regular
- Joined
- Jan 11, 2005
- Messages
- 50
Hi,
Column B is a date column (Start Date) and I've used Data Validation to restrict the entries to dates after Jan 1, 2011. I've done the same in column D (End Date).
I'd like to restrict column D to be greater than or equal to column B. Is there a way to create a custom Data Validation that:
1) value must be a date
2) must be greater than or equal to Jan 1, 2011
3) must be greater than or equal to the corresponding date in column B.
If it is not possible I'd like to know too so that I don't waste anymore time on it.
Thanks
Column B is a date column (Start Date) and I've used Data Validation to restrict the entries to dates after Jan 1, 2011. I've done the same in column D (End Date).
I'd like to restrict column D to be greater than or equal to column B. Is there a way to create a custom Data Validation that:
1) value must be a date
2) must be greater than or equal to Jan 1, 2011
3) must be greater than or equal to the corresponding date in column B.
If it is not possible I'd like to know too so that I don't waste anymore time on it.
Thanks