Hi Joel

You are still not giving us the complete picture.
Do you have something like Date in column A and Value in Column B running
down through rows 1 to 30?

If so, then in C1
=IF(A1="","",TODAY()-A1)
copy down through C2:C30 and you will have the number of days for each of
the 30 items.


Regards

Roger Govier


joel wrote:
Hi,

Not sure what I need to do is possible then? To elaborate I have a
spreadsheet that shows 30+ pieces of live data updating from a server. I need
to create a system by which it automatically counts up the number of days
since the figures last changed for each of the 30 pieces seperatly.. if that
makes sense?




"Bob Phillips" wrote:


Joel,

You can't do what you want with a formula. If you put a formula in a cell,
that previous value is gone.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"joel" wrote in message
...

I need to create a formula that looks at a reference cell then returns
Today() if the cell is between given values. If the the cell is not

between

given values then the date in the output cell doesn't change, is this
possible???

Many thanks,

Joel