how do i set up a "balance over 30 days" field in an invoice?

G

Guest

I need to enhance an invoice with an area for "balance over 30 days". It
should calculate this by comparing the current date to the date the service
is completed.

Since we e-mail these invoices to the district office for payment to the
sub-contractor's, the date sent is not an issue, only the date service is
completed. There are often invoices that have gone past 30 days, some 60 or
more days, and an invoice or billing statement that included this is what I
need. I've briefly looked in Access, & find nothing there, either.
 
B

Biff

Hi!

Here's one way.

If cell A2 holds the service completed date, in cell B2
enter this formula:

=IF(OR(A2="",A2+30>=TODAY()),"","Balance over 30 days")

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel How to create a Accounts Receivable to calculate days in which payments against invoice are received 0
How to add 30 days to date in another column, including Sat/Sun? 2
Re: Excel Aged Receivable formula to calculate 0-30 days, 61-60 days,. 0
Allocate an income payment over a date range (tax years) 7
How to add 30, 60 and 90 days to date and calculate deepening disc 5
Running total over a find number of days 12
Invoice Amt. - Payments = Balance 2
summing up values with in date intervals 2

Top