Formula Help
 

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

Formula Help
 

Hi,

=if(B3<"",B3-A3,DATEDIF(A3,TODAY(),"d"))

"jlo" wrote:

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

Formula Help
 

Hi

Try this:

=IF(B3="";DATEDIF(A3,TODAY(),"d"),DATEDIF(A3,B3,"d "))

Regards,
Per


On 26 Apr., 18:41, jlo wrote:
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

Formula Help
 

=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!

--------------------
(Ms-Exl-Learner)
--------------------


"jlo" wrote:

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

Formula Help
 

Thank you. Works!

"Eduardo" wrote:

Hi,

=if(B3<"",B3-A3,DATEDIF(A3,TODAY(),"d"))

"jlo" wrote:

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

Formula Help
 

"jlo" wrote:
=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

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


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

"jlo" wrote:
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