"Invalid Data Type" Error - Need Formula Help!

Ashley Pierce

721626f0-f362-42bb-8a36-1c6492c88b26.PNG

I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank.

=DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row))

Carson Penticuff

Add an IFERROR

=IFERROR(DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row)), "")

Razetto

@Ashley Pierce Try using the iferror:

=IFERROR(DATE(YEAR([Column2]@row) + 3, MONTH([Column2]@row), DAY([Column2]@row)), "")

Carson Penticuff

Add an IFERROR

=IFERROR(DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date Completed]@row)), "")

Peggy Parchert

@Ashley Pierce

Hello! Try wrapping an IFERROR around your formula.

Thanks, Peggy

Ashley Pierce

Y'all are the best! Thank you