overdue

A

Ania

Hello,

I have two columns: Due Date and Overdue. I need to
calculate an Overdue from passed Due date. How do I set a
formula?

Thanks,
Ania
 
C

CLR

With your Due Date in A2, put this formula in B2 and format cell B2 for
"Number" with no decimal places.........

=TODAY()-A2

Vaya con Dios,
Chuck, CABGx3
 
T

Tushar Mehta

One possibility:

=MAX(0,TODAY() - <Due-date-cell>)

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
 
Top