Date Formula Question :)

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,

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')