Days from calculator

[Sarah_Holmes]

Hi,
All the way from Australia, and I’m newish to Airtable and will probably have 100+ questions.
My first one is, can I calculate how many days there are from column B
e.g. Column A is the date a property was loaded online
column B is how many days a property has been online…
any help would be appreciated.
Thank you
Sarah

[Marko_Petrovic]

You can calculate difference between 2 dates by using DATETIME_DIFF() formula.
Syntax is DATETIME_DIFF(Date, Date2, ‘years’) where you define 2 dates you want to calculate difference and also define output format (‘year’ part, it can be days, hours, etc.)
Here is the support article with all the possible outputs of formula:

Airtable - Support

Supported unit specifiers for DATETIME_DIFF

The DATETIME_DIFF() function will allow you to calculate the difference between two different datetimes in specified units. Each specifier has a corresponding abbreviation which will work the same ...

[Sarah_Holmes]

Thank you so much! It’s working!!