Removal of #INVALID DATA TYPE
I have created the following formula which auto populates a cell with a date that is 3 years before the date in another field [Date Field]:
=DATE(YEAR([Date Field]@row) - 3, MONTH([Date Field]@row), DAY([Date Field]@row))
However, when there is no date in the source [Date Field] the return message is #INVALID DATA TYPE. Does anyone know how to replace this text with new text such as "No Launch Date" or "N/A" or "0" or even better leave as blank?
Help Article Resources
Check out the Formula Handbook template!