Skip to main content

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

  • September 14, 2022
  • 1 reply
  • 18 views

Forum|alt.badge.img+2

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

.

1 reply

Forum|alt.badge.img+16
  • Inspiring
  • September 14, 2022

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