I have two columns, one showing the dates when a file was completed, the other with the formula =IF(TODAY()-D2>365, "Overdue", IF(TODAY()-D2>335,"Due","OK")), to notify me when I need to renew the file (yearly) and when they're overdue. However I'm not sure how to include an "ignore blank" statement in that formula for files that have no completed dates yet.
If you want it to do nothing or show a blank if D2 is blank, then use this
Formula:
Please Login or Register to view this content.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks