I'm no wiz when it comes to Excel, so I hope you don't mind my n00bness.
Column H is the date something was sent out.
Column I is the date something was returned.
Column J is the total days between. (I1-H1=J1)
I want Column J to calculate the total days from the date something was sent out to the current date if Column I is blank.
Example:
(H= 06/17/13)(I = 06/24/2013) therefore (J = 7)
(H= 02/01/14)(I = N/A) if it was today, (J = 5)
Anyone know how to write a formula like this?
Bookmarks