44:
159:
The most common issue raised by the year 1900 problem regards people's ages. Often, a person's birth year was registered with only two digits, on the assumption that either it was not important exactly how old a person is, or that no one lives longer than one hundred years. In several countries,
190:
number to store dates and times. The number 1.0 represents the first second of
January 1, 1900, in the 1900 Date System (or January 2, 1904, in the 1904 Date System – the default for Macintosh prior to Excel 2016). Numbers smaller than this display as a
202:, the 1900 Date System incorrectly accepts the date February 29, 1900, even though 1900 was not a leap year. This also has the side effect that the WEEKDAY function reports incorrect values for the period Jan 01 1900 to Feb 28 1900.
170:
When handling the year 2000 problem, measures were sometimes taken to avoid or rectify this: modifying the national identification number, for instance. For example, year is recorded only with two digits in
Bulgarian
175:; however, a solution was ready as early as the inception of the system in 1975: 20 was added to the month number for an individual born before 1900 and 40 for those born in or after 2000.
186:(using the default 1900 Date System) cannot display dates before the year 1900, although this is not due to a two-digit integer being used to represent the year: Excel uses a
167:
The largest unwelcome side effect from this is people 100 or more years old being mistaken for young children or in some cases, young children being mistaken for adults.
347:
241:
494:
144:
concerns the misinterpretation of years recorded by only their last two digits, and whether they occurred before or after the year 1900. Unlike the
20:
340:
61:
127:
429:
424:
388:
383:
211:
108:
303:
80:
333:
161:
65:
87:
267:
94:
54:
187:
245:
76:
458:
414:
172:
463:
393:
153:
221:
101:
468:
445:
419:
398:
378:
373:
149:
145:
32:
164:
was introduced (often in the 1950s), including two-digit information about the birth year.
183:
28:
24:
19:
489:
483:
291:
216:
199:
43:
325:
68: in this section. Unsourced material may be challenged and removed.
18:
329:
37:
304:"Excel incorrectly assumes that the year 1900 is a leap year"
268:"Differences between the 1900 and the 1904 date system"
438:
407:
361:
156:did and has also cropped up in manual systems.
341:
8:
292:How to Work With Dates Before 1900 in Excel
348:
334:
326:
128:Learn how and when to remove this message
244:. WBAL-TV. March 8, 2006. Archived from
152:alone, since the problem existed before
242:"5-Year-Old Boy Summoned For Jury Duty"
233:
7:
66:adding citations to reliable sources
14:
495:Time formatting and storage bugs
430:Years 32,768 and 65,536 problems
212:Time formatting and storage bugs
42:
53:needs additional citations for
362:Decimal or BCD storage related
162:national identification number
1:
439:Hexadecimal storage related
511:
454:
23:February 29, 1900 in the
160:especially in Europe, a
459:Time computing problems
198:For compatibility with
408:Binary storage related
35:
356:Year-related problems
248:on September 30, 2011
22:
173:Uniform civil number
154:electronic computers
148:, it is not tied to
62:improve this article
464:Time code ambiguity
415:2036 NTP wraparound
394:Year 10,000 problem
77:"Year 1900 problem"
16:Time formatting bug
272:docs.microsoft.com
222:Perpetual calendar
36:
477:
476:
446:Year 2010 problem
425:Year 2108 problem
420:Year 2038 problem
399:Leap year problem
389:Year 2100 problem
384:Year 2042 problem
379:Year 2011 problem
374:Year 2000 problem
369:Year 1900 problem
150:computer software
146:year 2000 problem
142:year 1900 problem
138:
137:
130:
112:
33:Microsoft Windows
502:
350:
343:
336:
327:
320:
319:
317:
315:
300:
294:
289:
283:
282:
280:
278:
264:
258:
257:
255:
253:
238:
194:
133:
126:
122:
119:
113:
111:
70:
46:
38:
510:
509:
505:
504:
503:
501:
500:
499:
480:
479:
478:
473:
450:
434:
403:
357:
354:
324:
323:
313:
311:
302:
301:
297:
290:
286:
276:
274:
266:
265:
261:
251:
249:
240:
239:
235:
230:
208:
192:
184:Microsoft Excel
181:
179:Microsoft Excel
134:
123:
117:
114:
71:
69:
59:
47:
29:Microsoft Excel
25:Polish-language
17:
12:
11:
5:
508:
506:
498:
497:
492:
482:
481:
475:
474:
472:
471:
466:
461:
455:
452:
451:
449:
448:
442:
440:
436:
435:
433:
432:
427:
422:
417:
411:
409:
405:
404:
402:
401:
396:
391:
386:
381:
376:
371:
365:
363:
359:
358:
355:
353:
352:
345:
338:
330:
322:
321:
310:. May 21, 2020
308:Microsoft Docs
295:
284:
259:
232:
231:
229:
226:
225:
224:
219:
214:
207:
204:
188:floating-point
180:
177:
136:
135:
50:
48:
41:
15:
13:
10:
9:
6:
4:
3:
2:
507:
496:
493:
491:
488:
487:
485:
470:
467:
465:
462:
460:
457:
456:
453:
447:
444:
443:
441:
437:
431:
428:
426:
423:
421:
418:
416:
413:
412:
410:
406:
400:
397:
395:
392:
390:
387:
385:
382:
380:
377:
375:
372:
370:
367:
366:
364:
360:
351:
346:
344:
339:
337:
332:
331:
328:
309:
305:
299:
296:
293:
288:
285:
273:
269:
263:
260:
247:
243:
237:
234:
227:
223:
220:
218:
215:
213:
210:
209:
205:
203:
201:
196:
189:
185:
178:
176:
174:
168:
165:
163:
157:
155:
151:
147:
143:
132:
129:
121:
110:
107:
103:
100:
96:
93:
89:
86:
82:
79: –
78:
74:
73:Find sources:
67:
63:
57:
56:
51:This section
49:
45:
40:
39:
34:
30:
26:
21:
368:
312:. Retrieved
307:
298:
287:
277:November 24,
275:. Retrieved
271:
262:
250:. Retrieved
246:the original
236:
197:
182:
169:
166:
158:
141:
139:
124:
115:
105:
98:
91:
84:
72:
60:Please help
55:verification
52:
217:System time
200:Lotus 1-2-3
27:version of
484:Categories
228:References
88:newspapers
252:March 31,
118:July 2024
314:July 30,
206:See also
195:error.
193:#VALUE!
102:scholar
104:
97:
90:
83:
75:
469:Epoch
109:JSTOR
95:books
490:1900
316:2020
279:2019
254:2017
140:The
81:news
31:for
64:by
486::
306:.
270:.
349:e
342:t
335:v
318:.
281:.
256:.
131:)
125:(
120:)
116:(
106:·
99:·
92:·
85:·
58:.
Text is available under the Creative Commons Attribution-ShareAlike License. Additional terms may apply.