Variable in DATEONLY formula to allow for a non-date value

Dana S

I am pulling info from a date column on a project sheet, but in some cases the date value is "N/A" (which is not a date value). I have a secondary colum in my metadata that feeds a portfolio summary sheet. Currently is a formula that is DATEONLY, but I need it to be able to return the "N/A" value instead of "INVALIDDATA". What is the best way to revise this formula?

=DATEONLY(Date@row) + ""

TVang

Hi, @Dana S, modify your formula to = IFERROR( DATEONLY(Date@row), "N/A") this will catch the error when the value of Date@row is not a date.

TVang

Hi, @Dana S, modify your formula to = IFERROR( DATEONLY(Date@row), "N/A") this will catch the error when the value of Date@row is not a date.

Dana S

That worked! Thank you very much for your assistance.