Note that DAYS360() will give inaccurate answers due to its using 30 day
months. For instance

A1: 9/23/2004
A2: =DAYS360(A1, TODAY())

A2 returns 365 for today (27 September 2005) even though the actual
interval is 370 days.

Better to use

=(TODAY()-A1)365

instead.

In article ,
"David Billigmeier"
wrote:

In the conditional formatting box choose "Formula Is" and enter this:

=DAYS360(A1,TODAY())365

Of course, change the 'A1' reference to whichever cell you are currently in.