How can I update a date cell to change to the following year automatically?
VLD
✭✭
Hi,
Hoping someone can assist.
I have a sheet with automations built in. Basically, a form is sent out on each respective date and then the QTR column updates to the next QTR. So Q2 date reached, form sent and QTR column updates to Q3.
What I want to know - Is there any way I can then have my Q2 date updated to 01/07/24?
Below is an snippet of my sheet if it helps.
Thank you in advance.
Best Answer
-
Try something like this:
=DATE(YEAR(TODAY()) + IF(TODAY()> DATE(2023, 07, 01), 1, 0), 07, 01)
Answers
-
Try something like this:
=DATE(YEAR(TODAY()) + IF(TODAY()> DATE(2023, 07, 01), 1, 0), 07, 01)
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