counting days and stopping

[tdeeds]

i have two cells

A1 can be selected for open or closed

A2 is the days counter that counts how many days an item is open

i want to be able to select close and make the days counter stop so that i can see once its closed how many days that item was open for before we closed it. is that possible?

also, is there anyway to take two dates in different cells lets say F3 and F6 and calculate in another cell using whichever one of those two dates is latest?

 

[cerfani]

How does the days counter work? Is this a macro you wrote?

 

[tdeeds]

=+(TODAY())-F3 is the formula to count days

so, A3 has the closed or open drop down

B3 has the days counter, based off the date in F3

im trying to stop the counting of days once i click closed

 

[cerfani]

paste the value after u calculate it

 

[tdeeds]

is there anyway to stop the counting of days.

 

[cerfani]

copy cell->right click cell->paste special->values only

good luck