hi all.
how to make formula in data validation for this condition:
in col B contains type of rent car like toyota, honda, etc. with input start date & end date (due date)
i want to if when i choice in cell B2 e.g. toyota and not yet due date (col D2) so when i choice again toyota in cell B3 the system is not allowed cause still not due date (1/4/2022)
my desired result in cell b2 down
please, check this link sharing
https://docs.google.com/spreadsheets...it?usp=sharing
for anyone help, thank in advance
john m
Bookmarks