The base date for date and time data in Excel 2016 is ________.
A) January 1, 1000
B) January 1, 1900
C) December 31, 999
D) December 31, 1899

Question

Quizplus · Accepted Answer

The base date for date and time data in Excel 2016 is January 1, 1900. This means that any date entered into an Excel cell is interpreted as the number of days that have passed since January 1, 1900. For example, January 1, 1900, is represented by the number 1, while January 1, 2019, is represented by the number 43,632.

The Base Date for Date and Time Data in Excel