Formula true/false if a date occurs this year

[rcp]

Hi,

I am making a finance spreadsheet that will have rows 10 years into the future but will only need this year's data at any one time. I'm looking a true/false formula for if a date occurs within this year to allow me to filter out all the false responses. Column A is my date entry, I'm doing one row per month and the format style is January 2020 (but Date & Time data format).

I thought it should be relatively simple: IF(A2=YEAR(TODAY()),1,0) but that doesn't seem to be working. Can anyone see where I'm going wrong?

 

[sandy666]

maybe =year(a2) = year(today())

 

[rcp]

maybe =year(a2) = year(today())

Brilliant – that's done it. Knew it would be straightforward – thanks!

 

[sandy666]

You are welcome