1 or more months automatic fill into different columns

pmack

I want to put a date in columns that are monthly increments off an entered date field. We want to have reminders when a site needs to be reviewed for warranty items. This is based off 'Planted Date'. I created 12 columns for each month we need to visit the site. I was able to enter the following formula and it works till it needs to roll over to 2026. I've tried +1 after the year but it did not work. Any help would be greatly appreciated.

=DATE(YEAR([Date Planted]@row ), MONTH([Date Planted]@row ) + 3, DAY([Date Planted]@row ))

Maybe there is an easier way to go about this. :) Any help is greatly appreciated.

FYI - I have created automations for each month.

Paul Newcome

You will need something like this:

=IFERROR(DATE(YEAR([Date Planted]@row), MONTH([Date Planted]@row) + 1, DAY([Date Planted]@row)), DATE(YEAR([Date planted]@row) + 1, MONTH([Date Planted]@row) - 11, DAY([Date Planted]@row))

The trick here is that the first number is the number of months into the future you want to add. The second number is subtracting from the month 12 minus the first number (and adding one to the year).

+1 / -11

+2 / -10

+3 / -9

+4 / -8

so on and so forth.

For 12 months, you would just add 1 to the year and ignore anything in the MONTH sections.