Hi all
I suspect this is a simple one but I have Friday afternoon brain....
I have a list of dates and need to calculate a duration, however I want it to return nothing if one of the dates is blank, how can I do this? Example attached...thanks in advance
Try this...
Entered in E2 and copied down:
=IF(COUNT(C2:D2)=0,"",IF(A2="apple",C2-B2,D2-B2))
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Thank you, that works perfectly.
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks