I have a column type Date
(the date is not ordered), and Today()
, how can I find the closest future date to Today()
and highlight a range of cells in the row?
Example: A1=07/20/20, A2=02/19/19, A3=02/19/21 (mm/dd/yy), so when I enter this spreadsheet today, A1 will be highlighted, if I enter this spreadsheet a week from now, A3 will be highlighted.
Thanks
Sample file: future_date.ods