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))
Help Article Resources
Check out the Formula Handbook template!