help with a formula

[tsedar]

Greetings, I need a function that will increase the number value in a cell each day. I am tracing properties and have a collum the represents the number of days a property has been on the market this number for each property cell should increase by 1

[#2]

@tsedar Suppose the "start date" is in A1, use this formula to determine how long the property has been on the market.

=TODAY()-A1

When the property gets sold you, obviously, want to include a check that this calculation is not done. Something like this:

=if(<sold>,"",TODAY()-A1)