IF/AND YEAR HELP!

Toosmartformesheet

Hi All,

New user and new to this community.

I am trying to do an IF(AND formula that returns a "Y" if there is a "1" in my first reference column, and a date falling within the next 12 months in a second date coloumn.

Thanks

Tom

Paul Newcome

Try something like this...

=IF(AND([First Column]@row = 1, [Date Column]@row >= TODAY(), [Date Column]@row <= DATE(YEAR(TODAY()) + 1, MONTH(TODAY()), DAY(TODAY()))), "Y")