Rick,
In response to your questions:
1) All of the date values within the files are constants that are not the result of a formula.
2) Yes there are formulas used throughout the files. There may be as many as 100 per worksheet and consist mostly of the following:
  • =Sum (range:range)
  • =LOOKUP(E21,$U$6:$U$83,$V$6:$V$83)
  • =(N22+L23)-(M23)


Thanks for your quick reply,

Dan