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