Formula to increase the year value in a date field
I created a billing form that's going to be used to capture future billings to clients. The form is set up to capture the 1st billing date & # of future monthly installments, and the sheet has the formula that populates the billing schedule (ie 2/15/22, 3/15/22, 4/15/22,...).
The error pops up when the formula has to return a value for 2023. Since the formula just adds 1 to the initial billing month, it returns 13/01/2022, instead of 01/01/2023 for something that needs to be billed in Jan 2023.
Is there a tweak I can make to the date formula to change it to the next year after Dec 2022?
This is the formula:
=IF([Recurring Billing Periods]@row > 2, DATE(YEAR([Date1]@row), MONTH([Date1]@row) + 2, DAY([Date1]@row)), "")
Help Article Resources
Check out the Formula Handbook template!