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”)
GCavin
(Gilles Cavin - Reinventing Formulas in monday.com)
2
Hi Lin,
Try:
FORMAT_DATE(SUBTRACT_DAYS({Load/Issue},10),"dddd, MMMM Do YYYY")
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.