This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Date format for formulas

Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast
Status: New Ideas
What is the proposed idea/solution?

Enable date formatting on formula columns

How does is solve the user problems?

My use case for this would be to insert templates or build template tables for project management on events we do over and over again. For example, if we plan a webinar, we know which tasks need to get done in what order and how many days apart. We have a formula for how many days before or after the live webinar date each task needs to be done. If I include a column for the live date and include the variance to live date, I should be able to auto calculate the due date for each task but there isn't a format that allows for this.

1 Comment
10 - Mercury
10 - Mercury

You can do this with formulas 🙂 

add/subtract days


DATEADD([date], [#], 'units')


to add/subtract non-weekend/non-holiday days


WORKDAY(startDate, numDays, [holidays])


to format text based dates to work with calendar views/filters/date formulas


DATETIME_PARSE(date, ['input format'], ['locale'])


and more!

Formula reference

You might also find record templates useful