Re: formula for days overdue

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.