Format calculated date colum

Hi we have created some calculated date fields but now get the long date. Wha’s the formula to add onto the end to fix. I have text(ADD_DAYS({Start Date},{# days},“MMM,DD,YYYY”)) and it returns NaN

@amac,

Instead of the TEXT() function use FORMAT_DATE():

FORMAT_DATE(ADD_DAYS({Start Date},{# days},"MMM,DD,YYYY"))

Jim