bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 831
- Office Version
- 365
- Platform
- Windows
Im not if fixing one of these formulas will fix the others but In cell J3 i have formula =I3+1825, I3 is a date. In K3 i have =J3-TODAY() and L3 I have =IF(K3<0,"EXPIRED",IF(K3<30,"EXPIRING SOON","IN DATE")). When I copy these down and I have blank rows I need them to just be empty.