This will be true when A5 is more than 48 hours prior to the start of today. If you want it to be more than 48 hours prior to the time at the moment, then use NOW instead of TODAY.
Formula:
=AND(ISBLANK(B5), B$4="Received", ISNUMBER(A5), TODAY()-A5>2)
Last edited by 6StringJazzer; 05-13-2016 at 11:21 AM. Reason: Got A5 and TODAY reversed, fixed it.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks