Countifs for NEXT year
I know to get current year I can just do YEAR(TODAY())
I just need to know how to make it look at the next year "2023" and then the following year "2024" without having to change it again at the beginning of the year. etc. I always want to look at the next 3/5 years.
I did try YEAR(TODAY()+1) but that didn't do it.
Any help would be great!
Joe Goetschel | Associate Director, Smartsheet
CrossCountry Consulting - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
Best Answer
Answers
-
I think I got it to work, YEAR(TODAY())+1
Seems to work I just wont know if it broke until 2023 :)
Joe Goetschel | Associate Director, Smartsheet
CrossCountry Consulting - Smartsheet Partner
"The only real limitation of Smartsheet is the level of effort required to achieve your goal."
-
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!