NaN/NaN/NaN result in Formula

When using template program DocuGen we needed to create a formula so dates would show in the US format: MONTH({Date of Exam}) & “/” & DAY({Date of Exam}) & “/” & YEAR({Date of Exam}). However if the date column is empty it comes over as NaN/NaN/NaN I’ve done some digging and couldn’t find a way to rename this something else if blank for Dates. I’ve tried a few including TEXT at the beginning but it didn’t work. Does anyone have a suggestion? @JCorrell


Here’s one way:
FORMAT_DATE({Date of Exam},"MM/DD/YYYY")

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday

1 Like

Wonderful! This is better than my previous formula, and it leaves the blank columns blank, as it should! Also translates perfectly on the template. Thank you!