Simple as the Title states: If year of a date matches the year of any date in a range of dates, return true. The only thing is, I'm trying to find a way to write a function that doesn't require me to individually compare the first date to each date in the range. For example:
=If(OR(YEAR(A1)=YEAR(C1),OR(YEAR(A1)=YEAR(C2),OR(YEAR(A1)=YEAR(C3),"TRUE","FALSE")
The closest I've gotten is:
=IF(YEAR(C1:C3)=YEAR(A1),"TRUE","FALSE")
But that doesn't work obviously… any help is appreciated!
Bookmarks