When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.

Name: When a year value lower than 30 is entered in a cell,for example 2/12/18,Excel assumes that the date is in the 21ˢᵗ century.
Brand: Quizplus
Rating: 4.7 (40 reviews)

Question

Quizplus · Accepted Answer

This is because Excel assumes that any two-digit year value between 00 and 29 is in the current century (i.e. the 21st century), and any two-digit year value between 30 and 99 is in the previous century (i.e. the 20th century).

When a Year Value Lower Than 30 Is Entered in a Cell,for