L
Lance Hebert
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.
=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.