Help

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

Topic Labels: Formulas
545 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Abdelraouf_Alka
4 - Data Explorer
4 - Data Explorer

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