Who knows with such an ambiguous problem statement?

How are the dates changing?

If the difference is 4 years and 1 day, it's because the users have a
different Date system selected (Tools/Options/Calculation).

It could be that there's a NOW() or TODAY() function (or some other
volatile function such as RAND()) in the data range.

It could be that there's a macro operating.

It could be user intervention.

Does it happen with all users?
Do you have any automacros or event macros in the workbook?
Do you have any volatile functions in the data range?


In article ,
rodger wrote: