Skip to main content

Airtable formula to convert X calendar dates into number of days

  • April 13, 2022
  • 1 reply
  • 17 views

Forum|alt.badge.img+6

Hello,

I want to calculate the number of days of a mission,

  • either from a period of time with beginning and end dates - which I can do with the [ DATETIME_DIFF() function]

  • or (and this is where I have an issue), from a list of specific dates. I want to make the sum of theses days. What is the formula for that please?

1 reply

Databaser
Forum|alt.badge.img+25
  • Brainy
  • April 19, 2022

Hi @Elodie_Delneuf and welcome to the community!

I’m assuming that this is a selection field and thus outputs a text, rather than a date. If that is the case, you could try using DATETIME_PARSE() in combination with a DATETIME_DIFF().