Re: Days from calculator

592 1
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2
7 - App Architect
7 - App Architect

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:

Thank you so much! It’s working!!