Make sure calculation is set to automatic:

ToolsOptonsCalculation tabAutomaticOK

--
Biff
Microsoft Excel MVP


"RED" wrote in message
...
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!