How to get formula to only show right date format?

[gracemeyer]

Hello all!

I have this formula (attached) to show the date 90 days from the close date of a deal. Instead of this long date format with irrelevant info how can I get the date formatted to look like the Actual Close Date column?

Thanks in Advance!

[dmccarthy22710 (Desiree McCarthy | Monday.com Ambassador)]

Try this FORMAT_DATE(ADD_DAYS({Actual Close Date}, 90), “MMM DD, YYYY”)