I am trying to have a column to show me the next date of a given month and day.
For example, I have a column that has contract renewal dates. These would be
Jan 1
Aug 1
September 1
December 1
Etc …
I would like the column next to it to figure out the next date based on todays date. If today is August 28, These values would be:
Jan 1, 2025
Aug 1, 2025
Sept 1, 2024
December 1, 2024
Is this possible? I've tried researching but can't find this specific answer. Thanks in advance!
Answers
-
@Herculean You'll need to create one or more helper columns to convert this.
For the Month you'll have a series of if() statements (12 in total) that say if( Jan, 1, if feb, 2 etc. Then you can use a =date() function to pull the text from the right() side of the string all in all ending up with an actual date column created from the string.
Certified Platinum Partner
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.1K Get Help
- 444 Global Discussions
- 142 Industry Talk
- 472 Announcements
- 5K Ideas & Feature Requests
- 83 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 489 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!