Nel post
*AndyL82* ha scritto:

Hi,
I have a list of birthdays in my Excel spreadsheet. I would like the
cell containing the date to change colour when the birthday is
approaching (14 days before the date). To do this I have come up with
the following to enter in the Formula Is box..
=IF(AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A5),DAY(A5))<15,TODAY()-DATE(YEAR(TODAY()),MONTH(A5),DAY(A5))0))
However, Excel suggests there is an error - any idea what is wrong?
Thanks!!
Andy

Hi Andy,
put this formula in the Formula Is box:

=AND(TODAY()-DATE(YEAR(TODAY()),MONTH(A15),DAY(A15))<15)

--
Hope I helped you.

I'm not sure of names of menues, option and commands, because
translating from the Italian version of Excel...

Ciao

Franz Verga from Italy