Welcome!

IF(AND Today not working correctly. Please help

Heath Sanders · 2017-09-11T00:41:21+00:00

=IF(AND([Last Contact Date]2 - TODAY() 120), "3-6 Mths")

=IF(AND([Last Contact Date]2 - TODAY() < 90, [Last Contact Date]2 - TODAY() > 120), "3-6 Mths")

Hi Heath,

it seems that you've flip-flopped the greater than and the less than signs in your formula. you'll want to swap the two and have >90 and <120.

Hope this helps.

Unless you are getting a specific error message, it appears like Andrew's suggestion is accurate.