LinkBack URL
About LinkBacks
Try this in cell M1
Formula:
=IF(AND(I1=0,J1=0),TODAY()-H1,IF(AND(I1=0,J1>0),TODAY()-J1,IF(AND(I1>0,J1>0),I1-J1,IF(AND(I1>0,J1=0),I1-H1,0))))
Try this in cell M1
Formula:=IF(AND(I1=0,J1=0),TODAY()-H1,IF(AND(I1=0,J1>0),TODAY()-J1,IF(AND(I1>0,J1>0),I1-J1,IF(AND(I1>0,J1=0),I1-H1,0))))
Don't just use the answers provided for you. Try to understand how it works by reverse engineering or asking about it.
Please mark the thread as [SOLVED] (Thread Tools->Mark thread as Solved) when answered.
If you're happy with an answer given, please click the * under the person's name to boost their reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks