Need help with IFERROR

Ashley McAdoo

I have a column with a formula that pulls the month out of a Completed Date column, but if there is no completed date I get "Invalid Data Type". My original formula is =MONTH([OR Completed Date])@row), which works, but I'd like to use the IFERROR so there isn't a whole column of "Invalid Date Type". I tried =IFERROR(MONTH([or Completed Date]@ROW, " ")), but it's returning an #INCORRECT ARGUEMENT SET. Thoughts? Suggestions?

Thanks,

Ashley

IFERROR.JPG

Eric Law

@Ashley McAdoo You just have your parenthesis in the wrong spaces. Try

=IFERROR(MONTH([OR Completed Date])@row),"")

Eric Law

@Ashley McAdoo You just have your parenthesis in the wrong spaces. Try

=IFERROR(MONTH([OR Completed Date])@row),"")

Ashley McAdoo

Hey @Eric Law,

I made one small change and it works! =IFERROR(MONTH([OR Completed Date]@row), "")

Thanks so much!