I don’t understand your last message, but I’ve created a simpler formula that works:
IF(Sale, DATETIME_DIFF( Sale, Purchase,'d'),DATETIME_DIFF( TODAY(),Purchase,'d')).
You can see my table: https://airtable.com/shrM7rGbN4msFSGPT
= ""with the Sale Date
Sale, as it’s a Date field