Do your formulas have absolute references ($A$1 instead of A1)? That would
keep them pointing to the first cells no matter how many times you copied
them.

Or, is your calculation mode set to manual? Press F9 to manually recalc the
worksheet.

Hope this helps,

Hutch

"RED" wrote:

I am trying to calculate the days between two dates. I have used both
equations =a1-b1 and =days360(a1,b2) and both have worked in the first cell.
I need to copy this equation to over 400 more lines. When I copy the
equation it gives the right equation in each cell, however the value is the
same value as the first cell.. Help please!
--
Thanks for your help!