A daily computation formula?

J

Jim Hutchison

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
 
P

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


Jim Hutchison said:
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
Click to expand...
paying invoices, and I want to have a column that shows how many days past
due an invoice is.
 
Top