EDATE to display "na"

[theexceldunce]

Hello could anyone tell me the correct formula to the below?

My current formula is =EDATE(J165,L165) which returns a #VALUE! error

J165 has the text "na" so I would like this also printed in the cell with the EDATE formula (n165)

Thanks in advance

 

[T. Valko]

Hello again,

Thanks for your speedy reply, hope this makes it a bit easier to understand what I am trying to acheive.

i1 Jan-10 (user input mmm-yy)
j1 Jan-10 (user input mmm-yy)
k1 12 (this number is generated by different formula)
l1 24 (this number is generated by different formula)
m1 Jan-11 (generted by formula) =IF(COUNT(I2,K2)=2,EDATE(I2,K2),"NA")
n1 Jan-12 (generated by formula) =IF(COUNT(J2,L2)=2,EDATE(J2,L2),"NA")

The numbers in K1 & L1 are added to the months in I1 & J1 so if I changed K1 to 13 the then M1 would change to Feb-11.

So if the month and year (in M1 & N1) has changed by one month or more above the current date then I would like cells A1:R1 to be highlighted red.

I am using 2007

Many thanks

Sorry, I'm not following you on this at all!

When you say "the current date", does that mean today's date?

Also, what are the cell values for:

I2,K2
J2,L2

Also:

i1 Jan-10 (user input mmm-yy)
j1 Jan-10 (user input mmm-yy)

Those dates are ambiguous. For all I know one date could be 1/10/2010 and the other could be 1/31/2010.