
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 30, 2021 10:11 AM
Hi! I am creating a task list template that has certain tasks that need to be completed 20 days prior to event, 14 days prior to event, 12 days prior to event, 2 days after the event, 7 days after the event, and so on. I’d love to be able to pop in the Event Date and it autopopulate real calendared DUE Dates based on those parameters so that I can use it over and over for each new event without manually typing in each due date for every single task, but am struggling to figure this out. Can someone please assist me? I am new to airtable and watching lots of tutorials!
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 30, 2021 04:18 PM
You want to create 5 formula fields using the DATEADD() function.
DATEADD({Event Date}, -20, "days")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 30, 2021 04:18 PM
You want to create 5 formula fields using the DATEADD() function.
DATEADD({Event Date}, -20, "days")

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 31, 2021 03:48 PM
@Kamille_Parks What if we need that end result date to be in working days?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 31, 2021 04:00 PM
Then use WORKDAY(). I would recommend familiarizing yourself with Airtable’s formula functions:

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Dec 31, 2021 04:08 PM
Thank you. I wasn’t sure if the WORKDAY() formula would be used instead of DATEADD() or in addition to, but I’ll try to work through this myself.
