Google Sheet : Data Validation With Expired Date

[muhammad susanto]

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
a cross posting

Googl Sheet : Data validation If Not Due Date [SOLVED]

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...

www.excelforum.com

for anyone help, thank in advance

 

[dwang]

Added my formula in cell E23. I would replace all the 3s with 2s and set the conditional formatting to C2:C.