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?
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?