Error in calculations from numbers derived from ro...

[brightler]

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

[TheTimeSavingCo · Accepted solution]

Try this: 

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

[brightler]

Perfect. Thank you