Formula Help

J

jlo

In my "Total Days" column, I have the following formula and it works:

E4 is Date sent to Vendor

=DATEDIF(A3,TODAY(),"d")

now, I want to add to this formula, if possible, to say if a date is entered
into the second column, then just calculate "Date Sent" - "Date Returned" in
the same "Total Days" column...is this possible?? I manually entered the "1"

Date sent to Vendor Date Returned From Vendor Total Days
out to Vendor
4/22/2010 4
4/22/2010 4/23/2010 1
4/23/2010 3
4/23/2010 3
4/23/2010 3
4/23/2010 3
4/26/2010 0
4/26/2010 0
 
M

Ms-Exl-Learner

=IF(AND(ISNUMBER(A3),ISNUMBER(B3)),DATEDIF(A3,B3,"D"),IF(ISNUMBER(A3),DATEDIF(A3,TODAY(),"D"),""))

OR

=IF(AND(A3<>"",B3<>""),DATEDIF(A3,B3,"D"),IF(A3<>"",DATEDIF(A3,TODAY(),"D"),""))

Remember to Click Yes, if this post helps!
 
J

Joe User

jlo said:
=DATEDIF(A3,TODAY(),"d")
now, I want to add to this formula, if possible, to say
if a date is entered into the second column, then just
calculate "Date Sent" - "Date Returned" in the same
"Total Days" column
Click to expand...

=IF(B3="",TODAY(),B3) - A3


----- original message -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I not count cells that have formulas in them 2
Pivot Table Summary Error? 6
Date Function 2
How can I add the values based the color of font and the date 1
Combine two sets of overlapping Date/Time data into 3 columns. 3
Is there a way to extract multiple values from an INDEX result ? 3
How can you replace specific characters in a string ? 2
Formula to display nearest following Thursday in mm/dd/yyyy format 1

Top