What formula do I use to add 12 months to a date?
Answers
-
Glad it is working for you.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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)))
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Many thanks Paul, that indeed does the trick!
-
@Cindy Van den Bremt Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
-
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!