## Using pre dates

The world, of course, didn't begin on January 1, 1900. People who work with historical information when using Excel often need to work with dates before January 1, 1900. Unfortunately, the only way to work with pre-1900 dates is to enter the date into a cell as text. For example, you can enter the following into a cell, and Excel won't complain:

July 4, 1776

You can't, however, perform any manipulation on dates that are actually text. For example, you can't change its formatting, you can't determine which day of the week this date occurred on, and you can't calculate the date that occurs seven days later. (See Figure 3-9.)

 Eai-pUi riuUtrri ■ rihdi-n • fruMwn Vur MWM* &*T WA1I "SiTIW XMmUJIH HDATEHW 7 Cktx« hVjn- rfr&- L7I2 2 22 Ubrumrf JX1712 * L7B to to ftijMfc^ÄLT« 1 ■■vwirllrvni LMJ 4 U «pNllllMJ ihihhu^W na i t« MwrtHtim LL IIOIIWNM IB* 4 M W^JKIDI ¥M4i ?55 TUMC»* feJM M 'WW U JbAh OurvyAdarm LJB7 7 II Mf £1_1»? 1) W«*JpSt>flr. 1*7 | O nKhftUfT L4 HflrVvtlw LW U 9 Br.mtni LiU I j AAiriHtwp HHnun 1771 2 1 1* JHW TiHf LfW k a wnÄlM KT.Sn IH S1.EZ7 JiM r»Hj!>iFv itki.1 JU lwi:r, 1.1M »1 Vi'dh U irwitP:fe 17» It 3 MnifTfetf 2,1,7» TT.ISÜ 111 Uondif SWvilMP I** H * «PWiifirl^Bli H.W in if HrimvdMin um i r h^l*1* r, iwp iub m iM-utr

Figure 3-9: The Extended Date Functions add-in lets you work with pre-1900 dates.

Figure 3-9: The Extended Date Functions add-in lets you work with pre-1900 dates.

4 PREV

NEXT