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
Solved
Calculate the number of days
+3Best answer by TheTimeSavingCo
Try this:
IF(
{Posession Date},
IF(
{Sold Date},
DATETIME_DIFF(
{Sold Date},
{Posession Date},
'days'
),
DATETIME_DIFF(
TODAY(),
{Posession Date},
'days'
)
)
)
+31Try this:
IF(
{Posession Date},
IF(
{Sold Date},
DATETIME_DIFF(
{Sold Date},
{Posession Date},
'days'
),
DATETIME_DIFF(
TODAY(),
{Posession Date},
'days'
)
)
)
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.