Skip to main content

Hi! I want to add a formula field that returns today’s date + a certain number of days. The number of days added to today’s data varies by row.


For example: Row one has a production time of 12 days, Row two has a production time of 4 days. I would like to add a column that takes today’s date, and adds 12 to it for the first row, and 4 to it for the second row.


Is this possible?


Thanks in advance,

M

Welcome to the Airtable community!


You are describing a formula like this, where {Production Time} is another column in the table:


DATEADD(TODAY(), {Production Time}, 'days')

However, the above formula will always show a new value every day.


Typically people calculate a date based on a fixed start date, such as the record creation date:


DATEADD(CREATED_TIME(), {Production Time}, 'days')

or date in another field:


DATEADD({Start Date}, {Production Time}, 'days')

Reply


Terms & Conditions