Skip to main content

Days from calculator

  • October 30, 2020
  • 2 replies
  • 26 views
S

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

    2 replies

    M
    Forum|alt.badge.img+3

    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:

    S
    • Sarah_Holmes
    • Author
    • New Participant
    • November 4, 2020

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

    Terms & ConditionsAccessibility statement