i want add a date automatic 6 months before the date show.
I Read through a number of posts, unable to find the right answer. I need some help to check if i want to purpurate the date as 6 months for the date below showing, how should i do the formula?
cheers,
Rane
Best Answer
-
Hello @Rane Yan
I think the following formula will work out for you.
=IFERROR(IFERROR(DATE(YEAR([Renewal Completion Date]@row), MONTH([Renewal Completion Date]@row) - 6, DAY([Renewal Completion Date]@row)), DATE(YEAR([Renewal Completion Date]@row) - 1, MONTH([Renewal Completion Date]@row) + 6, DAY([Renewal Completion Date]@row))), " ")
Answers
-
Hello @Rane Yan
I think the following formula will work out for you.
=IFERROR(IFERROR(DATE(YEAR([Renewal Completion Date]@row), MONTH([Renewal Completion Date]@row) - 6, DAY([Renewal Completion Date]@row)), DATE(YEAR([Renewal Completion Date]@row) - 1, MONTH([Renewal Completion Date]@row) + 6, DAY([Renewal Completion Date]@row))), " ")
-
Hi Protonspounge,
this is working well! Thanks so much!
Best Regards,Rane
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!