LinkBack URL
About LinkBacks
Dear expert
I need to solve task like
i have three dates A,B,C column A-START,B-END,C-ACTIVE
check with C If ACTIVE is not found then Check A-START IF START Have dates then Minus with End date other wise Result should be blank.
find the attachment
Dear expert
I need to solve task like
i have three dates A,B,C column A-START,B-END,C-ACTIVE
check with C If ACTIVE is not found then Check A-START IF START Have dates then Minus with End date other wise Result should be blank.
find the attachment
May be this
In E2 Cell
=IF(COUNTA(A2:B2)=2,B2-A2,"")
Drag it down..
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
Dude Again Thanks Alot You helped me again on my thread...... I want to be your follower...can i have your skype or email id?
Glad it helps you and thanks for the feedback
I will be always active here as long as I can
So we keep in touch here
Ok Thanks once again... Keep Helping Me... I have learned alot from your experience...
You’re welcome!
Yes, Surely
All of us learning from someone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks