Need help with IFERROR
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?
Help Article Resources
Check out the Formula Handbook template!