Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2024 06:19 AM
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! Go to Solution.
1 Solution
Accepted Solutions
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2024 07:09 AM
Try this: 
IF(
{Posession Date},
IF(
{Sold Date},
DATETIME_DIFF(
{Sold Date},
{Posession Date},
'days'
),
DATETIME_DIFF(
TODAY(),
{Posession Date},
'days'
)
)
)
2 Replies 2
Solved
See Solution in Thread
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2024 07:09 AM
Try this: 
IF(
{Posession Date},
IF(
{Sold Date},
DATETIME_DIFF(
{Sold Date},
{Posession Date},
'days'
),
DATETIME_DIFF(
TODAY(),
{Posession Date},
'days'
)
)
)
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Feb 07, 2024 09:38 AM
Perfect. Thank you
Reply
