Re: formula for days overdue

"Paul Ades" wrote...
>[EMAIL PROTECTED] (JAC) writes:
..
>>In plain english, if A2 is blank, then subtract the date in B2 from
>>today's date to get a number of days from due date.
>
>Try:
>
>=IF(AND(ISBLANK(A2),NOT(ISBLANK(B2)),TODAY()>B2),TODAY()-B2,"")

If diagnostics aren't needed if B2 were blank, then this can be done with just

=IF(N(A2)>0,TODAY()-B2,"")

In this case, negative and positive results indicate days before and after the
due date.

--
Never attach files.
Snip unnecessary quoted text.
Never multipost (though crossposting is usually OK).
Don't change subject lines because it corrupts Google newsgroup archives.