Formula Dates
 

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

Formula Dates
 

Hi

You could use Conditional Formatting.
Assuming your date are in column A, mark the range of cells concerned.
FormatConditional Formattinguse 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.

--

Regards
Roger Govier

"Goyo el Noyo" wrote in message
...
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