Skip to main content

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

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:


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!!

Reply


Terms & Conditions