Help

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

Date format for formulas

cancel
Showing results for 
Search instead for 
Did you mean: 
cerickso
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
Stephen_Orr1
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 https://support.airtable.com/docs/formula-field-reference#date_and_time_functions

You might also find record templates useful https://support.airtable.com/docs/using-record-templates-in-airtable