A daily computation formula?

[Guest]

Is there a way to create a formula that adds "1" to a number every passing day?
I have a spreadsheet that I use to calculate how late a company is on paying invoices, and I want to have a column that shows how many days past due an invoice is.

Can this be done? CAN excel operate a forula that automatically calculates each passing day?
please reply! Thanks!

Jimmy

 

[Peo Sjoblom]

Look at the today function

A1 holds the due date, B1 holds either "Paid" or empty then this formula
will tell you
how many days behind

=IF(B1="Paid","Paid","Vendor X is
"&TEXT(IF(A1<TODAY(),TODAY()-A1,0),"General")&" day(s) past due date")

--

Regards,

Peo Sjoblom

Is there a way to create a formula that adds "1" to a number every passing day?
I have a spreadsheet that I use to calculate how late a company is on

paying invoices, and I want to have a column that shows how many days past
due an invoice is.