Formula to count days from one specific date

[Nikolas_Da_Fons]

Hello guys !

So, i would like to create a formula that count days from a specific date. Something that would add 1 everyday. I hope im expressing my problem correctly :nerd_face:

Thanks

[Kamille_Parks]

That would be DATETIME_DIFF().

Airtable Support

Calculate the difference between two dates

Finding the difference between two dates can be helpful for many workflows. Using the DATETIME_DIFF() function in the example below, we'll find the difference - in days - between two dates. Note th...

[Nikolas_Da_Fons]

Thank you for your reply, im having trouble to express my problem i think. The DATETIME_DIFF would help me if there was an option to have alwais today’s date in the date cloumn. Me i want to count the days starting from on particular date. I want them to add 1 everyday.

Do you think there is a way to do this ?

[Kamille_Parks · Accepted solution]

As shown in that help article, you can use DATETIME_DIFF to calculate to or from “today” and/or to/from a specific point in time. If that static date isn’t in another field somewhere, then your formula would look something like either example below using Christmas 2021 as the static date:

DATETIME_DIFF(
  TODAY(),
  '2021-12-25',
  'days'
)

or

DATETIME_DIFF(
  TODAY(),
  DATETIME_PARSE('2021-12-24', 'YYYY-MM-DD'),
  'days'
)

[Nikolas_Da_Fons]

Thank you very much ! it works :slightly_smiling_face: