Question

Name two types of date in Excel
​

Answer 1

Answer:

Along with numbers, dates and times are the most common data types people use in Excel.

...

Dates in Excel

2 is 2-Jan-1900.

3 is 3-Jan-1900.

42005 is 1-Jan-2015 (because it is 42,005 days after January 1, 1900)

Answer 2

Answer:

• 2 is 2-Jan-1900.

• 3 is 3-Jan-1900.