Grilleman
02-12-2012, 12:01 PM
Hello -
I have two cells formatted to contain date values. If cell A1 contains a date value, cell B1 can only contain a date value prior to the date value entered in cell A1. If cell A1 is empty, cell B1 can contain any date value.
Is there a formula or VBA code that can accommodate my need.
Thanks!!
Grilleman
I have two cells formatted to contain date values. If cell A1 contains a date value, cell B1 can only contain a date value prior to the date value entered in cell A1. If cell A1 is empty, cell B1 can contain any date value.
Is there a formula or VBA code that can accommodate my need.
Thanks!!
Grilleman