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 | Smartsheet Director | SCS CLOUD - Smartsheet Partner

Save My Contact

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

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!