Prev: Formula addition causes random #REF!
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..
From: jlo on 26 Apr 2010 12:41
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



From: Eduardo on 26 Apr 2010 13:04
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
>
>
>
From: Per Jessen on 26 Apr 2010 13:07
Hi

Try this:

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

Regards,
Per


On 26 Apr., 18:41, jlo <j...(a)discussions.microsoft.com> 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

From: Ms-Exl-Learner on 26 Apr 2010 13:12
=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
>
>
>
From: jlo on 26 Apr 2010 13:44
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
> >
> >
> >
 |  Next  |  Last
Pages: 1 2
Prev: Formula addition causes random #REF!
Next: excel: How to set up a formula for a range of numbers ie. 3.5-5..