Date Displayed in Formula Column - change it

Help Please.

I have a formula that works to subtract number of days from a date on when an activity should start, SUBTRACT_DAYS({Load/Issue},10). The result shows as Day, Month, Year, Date and then hours, mins and seconds. I simply want Date, Month and Year. I’ve tried this, but it says, “illegal formula”. It is - SUBTRACT_DAYS(FORMAT_DATE({Load/Issue},10), “dddd, MMMM Do YYYY”)

Hi Lin,



Want to use your formula results in automations, widgets, calendars? It is now possible with the Advanced Formula Booster. This 3rd-party app allows you to create formulas that write to any type of column, breaking free of the Formula column.