jamie_lo75
New Member
- Joined
- Sep 7, 2022
- Messages
- 10
- Office Version
- 365
- Platform
- Windows
=IF(ISBLANK(RC[-1]),"Not Done",IF(RC[-1]+730<=TODAY(),"Expired",IF(RC[-1]<=TODAY()+30,"About to Expire","Valid")))
I need help guys, not sure how to explain, but I want the if statement to show EXPIRED after 2 years and About to Expire 1 month before but 2 years
*The Radiation Safety Column should have 2 years validity so I want to show, VALID, ABOUT TO EXPIRE & EXPIRED