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?