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

Email me!

"The only real limitation of Smartsheet is the level of effort required to achieve your goal."

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!