It certainly would! With today being Sep 28, 2005, and the prior date being
Sep 27, 2004, simple subtraction of the two dates gives 366, which, according
to the OP's requirements, should be overdue. DAYS360 gives 361, which is not
overdue.
DAYS360 is intended for financial calculations such as bond interest, etc,
where one assumes a year consists of 12 30-day months, or 360 days.
On Wed, 28 Sep 2005 17:59:38 +0100, Roger Govier
wrote:
Hi David
I wondered why you use days360?
Surely it would be more accurate to use
=(TODAY()-A1)365
Regards
Roger Govier
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.
|