EDATE cell to be blank when an error occurs

[SirHart]

Hey everyone, I would certainly appreciate some help. I am trying to get a cell to be blank if it errors.

I am using the:

=EDATE($I$2,M3)

function, but some cells I don't want filled in, so I return a #VALUE! error by entering the text "x" instead of a number in the M3 cell.

Is there a way to edit my formula in order for EDATE cell to just be blank or to at least read "0" or "Null"?

ANy help would be very appreciated!

 

[JamesW]

Hi,

Try:

=IF(ISERROR(EDATE($I$2,M3)),"",EDATE($I$2,M3))

 

[Joe4]

In versions 2007 or higher, use:
=IFERROR(EDATE($I$2,M3),"")

This one will work in any version:
=IF(ISNUMBER(M3),EDATE($I$2,M3),"")

 

[Andrew Poulsom]

Another way:

=IF(ISNUMBER(M3),EDATE($I$2,M3),"")

 

[SirHart]

Thank you! Sorry I forgot my version it is 2003, the =IF(ISNUMBER(M3),EDATE($I$2,M3),"") works like a charm! Thank you so much JamesW, Joe4, and Andrew Poulsom! You guys are life savers