My formula is not working, for one specific line in my task sheet. why does it not work

Evelina Dahl · 03/20/25

This is the formula, I receive Invalid in the cell

=IF(AND(MONTH([Start Date]@row) <= 1, MONTH([End Date]@row) >= 1, YEAR([Start Date]@row) <= 2025, YEAR([End Date]@row) >= 2025), 1, 0)

Soumitra Bhowmick · 03/20/25

Maybe if you can describe what you are trying to achive, I can help to correct it.

Soumitra Bhowmick · 03/20/25

Maybe if you can describe what you are trying to achive, I can help to correct it.

Evelina Dahl · 03/20/25

Hi,

thank you for coming back. I have received support. Problem is solved.

Best Answer