Solved

Calculate the number of days

2 years ago
February 7, 2024
2 replies
76 views

B

+3

brightler
New Participant

I need a formula that calculates the number of days we have owned a house.

Possession date to sold date and in the case there is no sold date I want it to calculate using today. TIA

Best answer by TheTimeSavingCo

Try this:

IF(
  {Posession Date},
  IF(
    {Sold Date},
    DATETIME_DIFF(
      {Sold Date},
      {Posession Date},
      'days'
    ),
    DATETIME_DIFF(
      TODAY(),
      {Posession Date},
      'days'
    )
  )
)

View original

This topic has been closed for replies.

+32

TheTimeSavingCo
Genius
Answer
2 years ago
February 7, 2024

Try this:

IF(
  {Posession Date},
  IF(
    {Sold Date},
    DATETIME_DIFF(
      {Sold Date},
      {Posession Date},
      'days'
    ),
    DATETIME_DIFF(
      TODAY(),
      {Posession Date},
      'days'
    )
  )
)

Adam, Airtable Consultant - https://thetimesaving.company