Calculating Days on Market using =DAYS

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!

Originally Posted by KatLane

but how do I keep that cell blank until there's a date in G3?

Try this:

=If(G3="","",DAYS(TODAY(),G3))

Thank you! That's perfect. It's blank now if there's no date in the live date.

But I'm still having the issue with it not updating when I enter the date.
Attachment 779469

I can manually trigger it by selecting the cell in the DOM column, clicking into the formula bar and hitting enter, but I don't want to have to do that every time...

Wait, I figured it out, so simple. My calculation options were set to manual 🤦*♀️

It's working perfectly now. Thank you