Hi,

I'm trying to calculate days on market for property listings based on a set start date and today's date, so that it's accurate whenever anyone looks at the spreadsheet.

I have used the formula =DAYS(TODAY(),G3) where TODAY is the end date, and G3 is where the start date is.

This works great! Except...
  • If there's no date in G3 then it returns the number 44687
  • It won't auto update the DOM column (which holds my formula) when I do enter a date

I understand that 44687 is the number of days since 1st Jan 1900, but how do I keep that cell blank until there's a date in G3?

Also, how do I get the DOM column to auto update when I enter a date without having to 'enter' the formula for it to recalculate?

Thank you!