Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Calculate the difference between two dates and add the first and last day

Topic Labels: Formulas
161 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hey all! I have recently started using Airtable. I have two date fields that show the number of days between the two dates, and I want to add the first and last day
Screen Shot 2022-09-13 at 1.37.44 PM
.

1 Reply 1

Hi @Abdelraouf_Alkady,
You always want to add two days to the difference? Or is there a time that the day of should count?

DATETIME_DIFF({Due Date},Date, 'days')+2