Which two digit year will Excel identify as in the twenty-first century and not the twentieth?
A) 88
B) 25
C) 31
D) 45
Answer is option B) 25
Explanation
By default, Excel determines the century by using a cutoff year of 2029, which results in the following behavior:
Two-digit year typed Century used
00-29 21st (year 2000)
30-99 20th (year 1900)