You'll also need a cell to record the date when the property is sold or
otherwise disposed of or your "on market" calculation will just continue to
grow.

Assume:

column A = list of properties
column B = date listed
column C = date sold or otherwise removed from the market

=IF(COUNT(B2),IF(COUNT(C2),C2,TODAY())-B2+1,"")

Once a date is entered in C2 the formula will stop increasing.

--
Biff
Microsoft Excel MVP


"accessnovice" wrote in message
...
No I don't have a date that the house went to market but I will add that
column and use your suggestion. Thanks for you help!

"Rick Rothstein (MVP - VB)" wrote:

Do you have the listing date in a column somewhere? If so, just use
either

=TODAY()-A1

or...

=TODAY()-A1+1

depending on if you count the listing day as day one or not.
Substitute
the
cell number containing the listing date for the A1 that I used.

There isn't a date in the column that I need to change daily.

I wasn't talking about a date that changes daily.


It is a housing listing and it states the days the home has been on the
market.

And my question to you was... Do you have a column for the date the house
was listed (or the date it went on the market) in your spreadsheet? If
so,
that cell address for that date is what you should use in place of where
I
wrote A1.


Rick