I have a list of dates that are input one after another.
I understand the validation proces that limits the entry only for dates
but the cell also need to be bigger than the some other cells.
=AND((AG2>=AF2),(AG2>=AE2),(AG2>=AD2))
But also I want the cell to accept only a date format not text or
number.
Meaning if you enter "a" or 2 it should show a warning asking for a
date format mm/dd/yy.
I hope I was clear in my request.
Brief my question is can a validating process include a cosutm
formating (date in my case) and refuse any other input which does not
correspond to the set criteria.