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