Here is what I am looking for I have a 3 list first is 'start date', 'end date' and third is 'Product'.
The LoV's are:
The requirement is that if start date is selected in cell A2 '2' column C2 should publish 'Pencil' and depending on the Start date the end date should have a date list equals or greater than start date i.e 2,3,4,5,6,7 (Date 1 should not be listed in List).
So basically it is dependent date validation but both list depends on list A.
Help on this would be much appreciated.
Thanks and Regards,