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.