| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
