Formula Dates

[Goyo el Noyo]

I'm building a database in excel with important dates through the year,
Birthdays, holidays and other special dates. I want to use a formula to sort
the dates, so every time I open the database can tell me what date (Birthday
or holiday) is closest, 3 days before that date.

thanks in advance

 

[Roger Govier]

Hi

You could use Conditional Formatting.
Assuming your date are in column A, mark the range of cells concerned.
Format>Conditional Formatting>use dropdown to select Formula
Is>=AND(A1-TODAY()>=0,A1-TODAY()<4)
Choose any Format you want to highlight the cells.

Any dates with 3 days of today's date will then be highlighted
automatically.