Re: formula for days overdue

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.

I get a #NAME error with this formula.



"RUSS BARTOLI" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> Or, enhanced to eliminate negatives:
> 
> @MAX(0,@IF(completed,completed,@TODAY)-due)