Jun 19 2023 12:49 PM
Jun 19 2023 10:43 PM
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.