What formula do I use to add 12 months to a date?

Paul Newcome

Glad it is working for you.

Cindy Van den Bremt

Hi,

I'm trying to do the same, except for me I'm adding a +1 to the month area, as I want 1 month after a marketing campaign, that a reminder is sent to gather KPIs.

I've adjusted the formula accordingly and it works, except for the month of December, whereby the formula correctly knows that there is no month in the same year after December, but it's not smart enough to in that case also perform a +1 to the year.

Not sure, how I can tweak any formula accordingly. Any suggestions welcome.

Paul Newcome

@Cindy Van den Bremt Try something like this...

=IFERROR(DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) + 1, DAY([Date Column]@row)), DATE(YEAR([Date Column]@row) + 1, 1, DAY([Date Column]@row)))

Cindy Van den Bremt

Many thanks Paul, that indeed does the trick!

Paul Newcome

@Cindy Van den Bremt Happy to help. 👍️

Becky Wilson

Hi - I am trying to have a date update the month and day when moving from one month to the next and the month, day and year when moving from one year to the next. For example, If today were 11/30/21, I would like to have the date for the next day to show 12/1/21. In addition, if today were 12/31/21, I would like the date for tomorrow to show 1/1/22.

I'm currently using this formula: =MATCH(MONTH(TODAY()) + "/" + DAY(TODAY() + 4 - WEEKDAY(TODAY())) + "/" + YEAR(TODAY()), $Monday3:$Sunday3)

The dates in Monday3 - Sunday3 are 12/13/2021. 12/14/2021. 12/15/2021. 12/16/2021, 12/17/2021

Sameer Karkhanis

You could have also used [Date Reviewed]@row + 365

Paul Newcome

@Becky Wilson If you are just looking for tomorrow's date, couldn't you use

=TODAY(1)

Becky Wilson

I moved off this. Sorry - we'll renew the sheet each year so won't need to go from year to year.

Thanks!

Becky Wilson