Excel time management often causes a despair: instead of a date, a number is displayed, e.g. 41615. It depends on the cellformat.
Excel stores dates as a serial number. By default, January 1, 1900 is equivalent to number 1, and for example, 1st January 2013 is 41275, or 22th September 2017 is 43000, and 18th July 2020 will be 44000! “3 secrets about Excel time management” bővebben