Formula - 30 days/60 days Automatically
Is there a formula that will calculate 30 days, 60 days, & 90 plus days for aged AR without having to change the date range each month? I don't want to change the months on each formula each month. This is what I'm using right now.
=SUMIFS([Invoice Amount]:[Invoice Amount], [Paid in Full]:[Paid in Full], "", [Project Name]:[Project Name], "Name", [Month End Date]:[Month End Date], @cell >= DATE(2023, 8, 1), [Month End Date]:[Month End Date], @cell <= DATE(2023, 9, 1))
Answers
-
A helper column with a formula in it, then reference that column in your formula.
someething like
=today()+30
=today()+60
=today()+90
or if you need it to update every month, you could create an automation that records a date on the first of the month in a helper column then you would have 3 extra columns:
=[helpercolumn]@row+30
=[helpercolumn]@row+60
=[helpercolumn]@row+90
Help Article Resources
Categories
Check out the Formula Handbook template!