Formula assistance - days within range

If(
[PROJ HANG NOTE]<>"","ALERT",
IsNull([ORIGINAL PROJECTED START DATE]),"PENDING",
[ORIGINAL PROJECTED START DATE]<=TODAY() + Days(15), "STARTED?",
[ORIGINAL PROJECTED START DATE] > TODAY() + Days(15) and [ORIGINAL PROJECTED START DATE] <= TODAY() + Days(20), "START NOW",
[ORIGINAL PROJECTED START DATE] > TODAY() + Days(20) and [ORIGINAL PROJECTED START DATE] <= TODAY() + Days(30), "START SOON",
[ORIGINAL PROJECTED START DATE] > TODAY() + Days(30) ,"ON RADAR"
)

Keep in mind it will evaluate from top to bottom, so as soon as it hits a true statement, it will put that status. Meaning, if there is something in Proj Hang Note, it will always say alert and never move on.

Also, I went fast so just double check the greater than or greater than/equals to and days to be sure it is what you want.

------------------------------
Mike Tamoush
------------------------------