So, what IS your formula?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lance Hebert" wrote in message
...
I know this is confusing and I have tried to make it clear, but seems as if
I
have failed at that.

DLW: When I copy the formula into other cells the result displays, but if
I
change information line that in effect changes the date that is part of
the
formula, the result does not change. The result does not recalculate and
so I
have to reenter the formula in order for the result to update based on the
new information.

FST1: I do understand the =Today() function. I misunderstood my own
thinking. What I have is a date range based on a "Due Date" column and
when I
copy the formula for these two date columns (date range), the formula
works
and displays correctly, but if I change a "due date", the formula does not
recalculate. I have to reenter the formula to recalculate.

I hope this clarifies it. Thank you both for your help.

"FSt1" wrote:

hi
i think you may have a slight misunderstanding about the Today()
function.
=today()-62 will not change until tommorrow no matter how much data you
type
into other cells. the only way you might be able to get the formula to
change
is to change it to ..say.. =Today()-A1 then plug different numbers in A1
to
subtract from today().

or did i miss something????

Regards
FSt1


"Lance Hebert" wrote:

I have a spreadsheet in which there are two cells with date ranges
based on
=TODAY() (ie. there is one column based on =TODAY()-62 and one based on
=TODAY()-58). I have copied the formula by dragging the formatting to
all of
the cells below the first line that I entered the formula in. Well now,
the
formulas are working by showing the dates based on the results, but I
change
the information on the line or insert a new line in the list, the
formulas
are not calculating. Again, the formulas are showing the correct dates,
but
the formulas are not showing up in the cells, thus when I enter new
information or line, the formulas are not calcuating.

I have checked that the sheet will automatically calculate, but it is
still
not working. Any suggestions? This may be an easy fix and I may be
making
this more difficult for me than it needs to be. Thanks for your help.