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.
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: