THANK YOU VERY MUCH!!! I love this forum!
--
Thank you,

scrowley(AT)littleonline.com


"T. Valko" wrote:

To shed some light on your actual problem:

=IF(B2="1 yr",EDATE(A2,12),IF(B2="2 yr",EDATE(A2,24)))
returns FALSE if "2 yr" or higher is selected.

That means what you *see* in B2 does not equal "2 yr".

There may be unseen characters like leading/trailing spaces:
<space2 yr
2 yr<space
<space2 yr<space

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this:

=EDATE(A2,LEFT(B2)*12)

Assuming you don't project beyond 9 yrs.

--
Biff
Microsoft Excel MVP


"SCrowley" wrote in message
...
Hi,

I've looked in this forum and the help feature in Excel and have only
partially succeeded.

I'm trying to return an Warranty Expiry Date based on date of receipt of
product.

Cell A2 has Date 9/06/08
Cell B2 has data validation list - "1 yr", "2 yr", "3 yr", etc.

Here are the two formulas I've played with:
=IF(B2="1 yr",EDATE(A2,12),IF(B2="2 yr",EDATE(A2,24)))
=IF(B2={"1 yr","2 yr","3 yr","4 yr"},EDATE(A2,{12,24,36,48}))

they work great if I have "1 yr" selected, it calculates 12 additional
months and returns 9/06/09, but returns FALSE if "2 yr" or higher is
selected.

I know I've missed it by just a comma or something. Any suggestions are
welcome.





--
Thank you,

scrowley(AT)littleonline.com