What formula do I use to add 12 months to a date?
Answers
-
Glad it is working for you.
-
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.
-
@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)))
-
Many thanks Paul, that indeed does the trick!
-
-
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
-
You could have also used [Date Reviewed]@row + 365
-
-
I moved off this. Sorry - we'll renew the sheet each year so won't need to go from year to year.
Thanks!
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!