Tag Archives: all excel formula details

Date Formulas and Functions in Microsoft Excel

Excel stores dates in sequential serial numbers beginning with January 1st, 1900 as 1.  January 1st, 2006 is 38718 because it’s 38,718 days after January 1st, 1900.  Excel on MAC works the same, except the dates start on January 1st, 1904. Don’t ask me why. Note: There are several different ways to do everything in […]