Re: formula for days overdue

Something like...


@IF(completed,completed,@TODAY)-due

??




"JAC" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Hope someone can help!
>
> My spreadsheet contains a "date due" column and a "date completed"
> column.
>
> I need a formula to calculate the number of days overdue, based on the
> current date, if the date completed column is blank.
>
> Thank you for any help!