How and where do you enter the date (Cell and sheetname)? Can you show us an
example of the formula that works on the other worksheets and an example of
the formula that does not work.

Tyro

"JMH" wrote in message
...
I am having trouble with cell referencing in a workbook. I have it set up
so
that I enter the date on the first sheet and then reference that cell on
the
following worksheets. This works on some of the worksheets but not on
others.
For some I get a #VALUE and for some it returns Jan. 0 1900.

The whole thing worked fine previously. I have no idea what to do about
this.