Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i set up a "balance over 30 days" field in an invoice?
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. |
#2
|
|||
|
|||
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 -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems with Pivot Table Field Sorting in Excel 2002 | Excel Discussion (Misc queries) | |||
how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
Pivot Tables..I give up... | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |