Forum Discussion
Stuznet
Helper V
7 years agoRolling and Trailing Year True False
Hi,
I've searched around but couldn't find the answer that I'm looking for. Basically, I'm trying to create a calculated column to show the current year and next year which is 2019 and 2020.
Here is the function I created but it only shows 2019.
Column = IF(AND([Year] = YEAR(TODAY()),-1), IF([Year] = YEAR(TODAY()), TRUE(), FALSE()))
How do I correct the function that will show both the years 2019 and 2020?
Here is the dummy file
much appreciated!!