Skip to main content

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

Try this: 

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


Perfect. Thank you