Re: formula for days overdue

[EMAIL PROTECTED] (JAC) writes:

>What I have right now is:
>
>=IF((A2,ISBLANK),B2-TODAY())
>
>where A2 is the date completed column and B2 is the due date column.
>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,"")