Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Countdown to target date instead of using a calendar date

Topic Labels: Dates & Timezones
229 1
Showing results for 
Search instead for 
Did you mean: 

I want to create a template for an event (or editorial) calendar where Day Zero is the date of the event/launch etc, and all tasks are relative to that target date. i.e. 10 days prior to launch or Day 10 or etc. How can I do this?

1 Reply 1

Hi @danw and welcome to the community!

Check out the DATETIME_DIFF() function for this.