Hello. I am trying to make a formula for work that I believe should be a nested IF function. I need the formula to tell me if the date is expired, if it is within 60 days of expiring, or if it is within 30 days of expiring. If it is further than 60 days to the expiration date, it should say something like good or valid. I am very new to excel and can't seem to figure out how to adapt an existing formula, though there are some that are close.
I tried using =IF(B2-TODAY()<=0, "EXPIRED", IF(B2-TODAY()<=7, "PENDING EXPIRATION", "OK")) but it doesn't quite do what I need.
Any help would be appreciated. Thanks.
Bookmarks