Date formula
Hi. I'm not sure how to go about this. I have a list that have SO Dates that are all different including the year. I plan is to send an automated reminder every 3 months from the SO DATE starting now. For example, I have an SO date of 08/06/23. Based on this, a reminder would have gone out on 11/6/2023 (which is the past). However, the next reminder would be going out on 2/6/2024. What would be the best formula and the best route of accomplishing this? I've thought about converting the date cells into MM/DD since the year to my result is not needed, but I cant figure out how to do that too. Any suggestions would be helpful. I also found a formula to add 3 months to the SO DATE, but that doesn't factor in year.
Answers
-
Hi @kat26
Is your SO Date column formatted as a date column?
Would sending the reminders every 90 days be acceptable or does it have to be 3 months?
When should the reminders stop?
-
Yes. the SO Date column is formatted as a date column.
I need the automated reminders to be sent out every 3 months from the SO date starting now. I tried the every 90 days but since some months have different amount of days then the actual date will be off from the SO date.
The reminders won't stop until I stop the automation.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!