Countifs for NEXT year

Joe Goetschel

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!

Kelly Moore

Hey @Joe Goetschel

A slight tweak to your formula - move your parenthesis

=YEAR(TODAY()) + 1

Joe Goetschel

I think I got it to work, YEAR(TODAY())+1

Seems to work I just wont know if it broke until 2023 :)

Kelly Moore

Hey @Joe Goetschel

A slight tweak to your formula - move your parenthesis

=YEAR(TODAY()) + 1