Sounds like you have some event code changing. Right-click the sheet tab
name and select code, check if there is code there.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Josh O." wrote in message
...
I setup a spreadsheet to automatically fill in a calendar for our company
fiscal year.

All the calculations run off the date entered into B2. The cell is
formated
to show the date in "mmm" format. Cell B3 = B2, but is formated as "d".
Then cell C2 and C3 are the next day, and so on.

When I enter a date into B2, it shows the correct abbreviation, but then
all
the formulas return a #VALUE! error and cell B2 changes from the date to
the
actual abbreviation that it is formated for.

For example, I enter 1/1/2007 and hit enter. The cell now reads "JAN" in
both the cell and the formula bar (where it should still read 1/1/2007).
Which then throws off all the other formulas.

Any ideas how to fix this?