Age of Invoice

Copper Contributor

I'm looking for a formula for age of an invoice.  The formula I was using, =A3-Today() is not working for me and I think it could be because it was from an old spreadsheet.  Thanks for the help!!

4 Replies

@Reddk6 

I put your question to the Bing chatbot. Here is its answer:

 

The formula you mentioned `=A3-TODAY()` calculates the difference between the date in cell A3 and today's date. This formula should still work in current versions of Excel. However, if you're having trouble with it, you might want to check the formatting of the cells to make sure they are formatted as dates.

To calculate the age of an invoice in days, you can use a formula that subtracts the invoice date from today's date using the `TODAY` function. For example, if your invoice date is in cell C5, you can use the formula `=TODAY()-C5` to calculate the age of the invoice in days ¹.

Is there anything else I can help you with?

Quelle: Unterhaltung mit Bing, 20.6.2023(1) Invoice age and status - Excel formula | Exceljet. https://exceljet.net/formulas/invoice-age-and-status Zugegriffen 20.6.2023.
(2) How to Calculate Age in Microsoft Excel - How-To Geek. https://www.howtogeek.com/757469/how-to-calculate-age-in-microsoft-excel/ Zugegriffen 20.6.2023.
(3) Subtotal invoices by age - Excel formula | Exceljet. https://exceljet.net/formulas/subtotal-invoices-by-age Zugegriffen 20.6.2023.

 

Thank you so much for the info! I will check the cells!
To calculate the age of an invoice in days, you can use a formula that subtracts the invoice date from today's date using the `TODAY` function. For example, if your invoice date is in cell C5, you can use the formula `=TODAY()-C5` to calculate the age of the invoice in days ¹.19-Jun-2023
 

@Junaidgeek1160 

Is that differ from @Detlef Lewin answer?