I am having major problems with formatting dates. When I enter 10804 and try
to format the cell (format,cells,number.date,03/14/98), the number in the
cell changes to 07/30/29. When I type 1/08/04, it changes to 3-79-94.

What is going on?? I tried going into tools, options, calculations, 1904
date system to see if the date program was off but when I tried that, it
changed 01/08/04 into 1/9/04.

I am at a complete loss and am going crazy.
I am entering dates as text right now, but I need to use these dates in
calculations.