Re: formula for days overdue

I figured it out, a little bit different than what you had:

=IF(ISBLANK(K2),F2-TODAY())

THANK YOU to all who offered help!


[EMAIL PROTECTED] (Paul Ades) wrote in message news:<[EMAIL PROTECTED]>...
> Harlan Grove<[EMAIL PROTECTED]> writes:
> >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.
> >
> 
> Perhaps better would be:
> 
> =IF(N(A2)>0, A2-B2, IF(N(B2)>0, TODAY()-B2, "" ))
> 
> Otherwise, the days overdue will always be compared to TODAY(), even after
> completion.  Also, until the project has been completed and a date entered in
> column A, nothing will be displayed in the overdue column.  My earlier formula
> showed NOTHING after the completion date was entered.