Excel treats 1900 as a leap year.

Yes, Microsoft knows about this. It’s a carry over from lotus 1-2-3 which did the same thing.

Microsoft points out that correcting the error would cause problems as date numbers in existing spreadsheets would now be off by one, and other issues would arise as well. It is also noted that since dates around 1900 are rare in ordinary applications this error shows up only rarely.

I wonder if carrying the error forward to ease compatibility with 1-2-3 saved work in the long run?

One Response to “Excel treats 1900 as a leap year.”

  1. CARL says:


    Pillspot.org. Canadian Health&Care.Best quality drugs.No prescription online pharmacy.Special Internet Prices. High quality drugs. Order pills online

    Buy:Ventolin.Lipothin.Nymphomax.Female Pink Viagra.Lasix.Aricept.Benicar.Prozac.Female Cialis.Zocor.Zetia.Acomplia.Cozaar.Buspar.SleepWell.Advair.Wellbutrin SR.Seroquel.Lipitor.Amoxicillin….