LinkBack URL
About LinkBacks
Try this...
In C2 Cell
=IF(A2="","",IF(B2="",IF(TODAY()<=A2,"Open","Overdue"),IF((B2-A2)<1,"Closed","")))
Try this...
In C2 Cell
=IF(A2="","",IF(B2="",IF(TODAY()<=A2,"Open","Overdue"),IF((B2-A2)<1,"Closed","")))
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks