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