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.

This is a little confusing- the formulas are showing the correct date, the
formulas are not showing up in the cells, and the formulas are not
calculating.

When you copy the original formula, what shows up in the cells that you
copied it to?

"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.

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.

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.

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.

Column C is date such as 3/20/2009
Column D formula is: =C2-62 (equaling 1/17/2009)
Column E formula is: =C2-58 (equaling 1/21/2009)

"Niek Otten" wrote:

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.

And if you change C2, D2 doesn't change? It should.
Check the setting for Automatic calculation once mo it changes if you
first load another workbook with another setting.
Try CTRL+ALT+SHIFT+F9 too (rebuild the dependency tree)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Lance Hebert" wrote in message
...
Column C is date such as 3/20/2009
Column D formula is: =C2-62 (equaling 1/17/2009)
Column E formula is: =C2-58 (equaling 1/21/2009)

"Niek Otten" wrote:

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.