IF Statement with Dates & Calculations

D

Diane

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

CLR

Put this in cell T2 and copy down....

=IF(I2="","n/a",IF(E2="","open",E2-I2))

Vaya con Dios,
Chuck, CABGx3
 
E

Eduardo

Hi,
in column T enter
=if(and(E2<>"",I2<>""),E2-I2,if(and(E2<>"",I2=""),"N/A","Open"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count if dates meet certain criteria 10
identify which years are contained within a range of dates 2
Finding most recent date for each customer - XL 2007 2
IF ARRAY with multiple conditions. 1
possible countif formula? 3
Check if a date comes before/after a range of dates 0
Extracting dates from a String 8
Return value from a Two Variable Data Table with Dates 1

Top