Skip to main content

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

  • September 14, 2022
  • 1 reply
  • 0 views
A

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

V
  • Vivid-Squid
  • Inspiring
  • 532 replies
  • 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
A
1 person likes this
  • A
    Abdelraouf_Alka

Reply


Most helpful members this week

Terms & Conditions