| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Statement with Dates & Calculations
I am trying to create a formula that looks at two dates, and based on the
results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with Dates & Calculations
Put this in cell T2 and copy down....
=IF(I2="","n/a",IF(E2="","open",E2-I2)) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with Dates & Calculations
It worked. Thank you!
"CLR" wrote: Put this in cell T2 and copy down.... =IF(I2="","n/a",IF(E2="","open",E2-I2)) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with Dates & Calculations
Happy to help.........thanks for the feedback.
Vaya con Dios, Chuck, CABGx3 "Diane" wrote: It worked. Thank you! "CLR" wrote: Put this in cell T2 and copy down.... =IF(I2="","n/a",IF(E2="","open",E2-I2)) Vaya con Dios, Chuck, CABGx3 "Diane" wrote: I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with Dates & Calculations
Hi,
in column T enter =if(and(E2<"",I2<""),E2-I2,if(and(E2<"",I2=""),"N/A","Open")) "Diane" wrote: I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF Statement with Dates & Calculations
Thank you for the reply. This formula also worked!
"Eduardo" wrote: Hi, in column T enter =if(and(E2<"",I2<""),E2-I2,if(and(E2<"",I2=""),"N/A","Open")) "Diane" wrote: I am trying to create a formula that looks at two dates, and based on the results places either a the calculation of number of days between the two dates, "n/a", or "Open" as the result Column E Column I Desired Results in Column T 1/11/2010 12/29/2009 13 1/11/2010 Blank n/a Blank 12/30/2009 Open Any help would be greatly appreciated. Please let me know if you need further explanation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| help with dates & calculations | Excel Worksheet Functions | |||
| If Statement - Date Calculations | Excel Discussion (Misc queries) | |||
| If Statement - Date Calculations | Excel Discussion (Misc queries) | |||
| Calculations using dates -- HELP! | Excel Discussion (Misc queries) | |||
| Removing Weekend dates from Day Calculations | Excel Discussion (Misc queries) | |||
Hybrid Mode
