Forum Discussion

Stuznet's avatar
Stuznet
Icon for Helper V rankHelper V
7 years ago
Solved

Rolling 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!!

  • Stuznet try this

     

    Column = IF([Year] = YEAR(TODAY()) + 1 || [Year] = YEAR(TODAY()), TRUE(), FALSE())

2 Replies

  • Stuznet try this

     

    Column = IF([Year] = YEAR(TODAY()) + 1 || [Year] = YEAR(TODAY()), TRUE(), FALSE())