?????????? ??? 1900 ? 1904 ????? ?????? ?? Excel

???? ???????: 214330 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
?????? ??? ????? Microsoft Excel 2000 ?? ??? ???????? ???? 180162
(http://support.microsoft.com/kb/180162/ )
.
????? ???? | ?? ????

?? ??? ??????

??????

????? Microsoft Excel ?????? ?? ??? ??????? ??????. ??? ??????? ???? ????? 1900 ????? ????? 1904. ???? ??? ??????? ????? ????? ??????? ????????? ???? ?? ??????? ??? ??????? ???????? ???? ?????? ????? ????? ???.
???? ??? ?????? | ????? ???????

??????? ????

???? ????? 1900

?? ???? ????? 1900? ????? ????? ????? 1 ?????? 1900. ????? ???? ?????? ?????? ??? ????? ??????? ?????? ????? ???? ???? ??? ?????? ???????? ??? 1 ?????? 1900. ?? ??? ???? ??????? ??? ??? ?????? 5 ????? 1998? ???? Excel ?????? ??????? ??? ????? ???????? 35981.

???? ???????? ?????? Microsoft Excel ? Windows ???? ????? 1900. ???? ???? ????? 1900 ????? ??????? ??? Excel ?????? ????? ???????? ??????? ??? Lotus 1-2-3? ???? ????? ????? ??? MS-DOS ?? Microsoft Windows.

???? ??????? 1904

?? ???? ????? 1904? ????? ????? ????? 1 ?????? 1904. ????? ???? ?????? ?????? ??? ????? ??????? ?????? ????? ???? ???? ??? ?????? ???????? ??? 1 ?????? 1904. ?? ??? ???? ??????? ??? ??? ?????? 5 ????? 1998? ???? Excel ?????? ??????? ??? ????? ???????? 34519.

???? ???????? ???? Microsoft Excel ???????? ?????? ???? ????? 1904. ????? ????? ????? ??????? ??????? ?????? ???? ??? ?????? ???????? ??? 1 ?????? 1904. ???? ??? ??????? ??? ??? ??????? ???????? ?????? ?? 1900 ?? ??? ??? ?????. ??? ??? ???????? ??? ???? ????? 1900? Excel ???????? ??? ???????? ??? 1 ?????? 1900.

????? ??? ????? ?????

??? ????? ??????? ????? ????????? ?????? ??????? ??? ????? ??? ??????? ???????? ????????? ?????? ?? ?? ???? ???????. ?? ??? ??? ???? ??????? 5 ????? 1998 ?? ????? ??????? ????????? ??????? ??? ???. 
                      Serial number
   Date system        of July 5, 1998
   ----------------------------------

   1900 date system   35981
   1904 date system   34519
????? ??? ??????? ?? ??? ??????? ??? 1462; ???? ?? ????? ???????? ??????? ?? "???? ?????" 1900 ?? ????? 1462 ?????? ???? ?? ????? ???????? ??????? ??? ?? ???? ????? 1904. 1462 ?????? ????? ????? ????? ???? ???? (??? ?? ??? ????? ???? ?????).

????? ???? ??????? ?????

?? Excel? ???? ?? ???? ?? ???? ???? ??????? ????? ?? ?????? ??? ?? ???? ??? ?????? ??????.

?????? ???? ??????? ????? ?? Microsoft Office Excel 2003 ??? ????????? ??????? ?? Excel? ???? ??????? ???????:
  1. ???? ?? ?? ???????? ??? ??????.
  2. ??? ????? ???????? ???? ??? ??????. ?? Excel X ?????????? ?????? ????????? ???? ??? ??????? ??? Excel ???????.
  3. ???? ??? ?????? ?? ????? ???????.
  4. ???????? ???? ????? 1900 ?? ??????? ???? ?????? ????? ????? ???? ????? 1904 . ???????? ???? ????? 1904 ?? ??????? ???? ?????? ???? ????? 1904.
  5. ???? ??? ?????.

?????? ???? ??????? ????? ?? Microsoft Office Excel 2007? ???? ??????? ???????:
  1. ???? ?? ?? ???????? ??? ??????.
  2. ???? ??? ?? Microsoft Office? ?? ???? ??? ?????? Excel.
  3. ???? ??? ?????.
  4. ???? ?????? ??????? ???? ???????? 1904 ???? ???????? ??? ??? ???? ??? ??????? ?? ???? ??? ?????.
???? ??? ??? ??? ?????? ???? ??????? ????? ???? ????? ?????? ??? ????????? shift ???????? ?????? ????? ???? ????. ?? ??? ??????? ??? ????? ????? ??????? ????????? ???? "????? ????? ????????" ??????.

????? ??? ???? ???????? ??? ????????

?? ???? ??????? ?????? ????? ????? ???? ??? ????? ???????? ???? ???? ??? ??? ?? ??? ???????? ??? ????????. ????? ???? ???????? ?? ???? ????? ??? ????? ????? ???? ????.

??????? ???? ?? ??? ??????? ???? ??? ???????:
  1. ?? Excel? ?? ?????? ?????? ???? (Book1 ? Book2).
  2. ???? ??????? ???????? ?? "????? ???? ??????? ???? ???? "???????? ???? ????? 1900 ?? ???? 1. ?????? ??????? 1904 ???? ?? Book2.
  3. ?? Book1? ???? ??????? 5 ????? 1998.
  4. ??? ?????? ???? ????? ??? ???????? ??? ?? ???? ??? ???? ??? ????? ???????.

    ?????? ?? Excel 2007? ??? ?????? ???? ????? ??? ???????? ??? ?? ???? ??? ???? ?? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.
  5. ?? ???????? ??? Book2 ???? ???? ?? ???? ??? ??? ??? ????? ???????.

    ?????? ?? Excel 2007? ?? ???????? ??? Book2 ??? ???? ??? ???? ??? ??? ?? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.

    ??? ??? ??????? ?????? 6 ????? 2002. ???? ?? ??????? ?? ????? ????? ???? ???? ?? ??????? ??????? ?? ?????? 3 ??? Book2 ?????? ???? ????? 1904.
  6. ?? Book2? ???? ??????? 5 ????? 1998. ??? ?????? ???? ????? ??? ??????? ??? ???? ??? ???? ??? ????? ???????.

    ?????? ?? Excel 2007? ???? ??????? 5 ????? 1998 ?? Book2. ??? ?????? ???? ????? ??? ?????? ??? ?? ???? ??? ???? ?? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.
  7. ??????? ??? Book1? ??? ???? ??? ?? ???? ??? ??? ??? ????? ???????.

    ?????? ?? Excel 2007? ?? ???????? ??? Book1 ??? ???? ??? ???? ??? ??? ?? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.

    ??? ??? ??????? ? 4 ????? 1994. ??? ?? ??? ????? ????? ????? ???? ???? ??? Book1 ?????? ???? ????? 1900.

????? ????? ????????

??? ??? ????????? ?? ?? ??? ???????? ??? ????????? ?? ??? ??? ????? ???? ??????? ????? ???? ????? ?????? ??? ????????? ???????? ?? ???? ????? ??? ????? ????? ???? ????. ????? ????? ???????? ??????? ??? ????? ??????? ???????:
  1. ?? ?? ???? ?????? ???? ?????? 1462.
  2. ??? ??????. ??? ????? ???????? ???? ??? ????.

    ?????? ?? Excel 2007? ??? ?????? ??? ?? ???? ??? ???? ?? ??????? ???????? ??? ?????? ???????? ?? ????? ???????.
  3. ??? ??????? ???? ????? ??? ???????? shifted. ??? ????? ???????? ???? ??? ??? ???.

    ?????? ?? Excel 2007? ??? ??????? ???? ????? ??? ?????? ???????? ???? ??? ??? ?? ??????? ???????? ??? ?????? ???????? ????? ???????? ??? ?? ???? ??? ??? ???.
  4. ?? ??? ??? ???? ??????? ???? ?????? ??? ???? ???????? ??? ???? ?? ???? ??? ?????? ?? ?? ????? ???????? ??????? ??? ???????.
          Select this     If
      --------------------------------------------------------------------

      Add             The dates must be shifted up by four years and one
                      day.

      Subtract        The dates must be shifted down by four years and one
                      day.
  5. ???? ??? ?????.
??? ??? ??????? ??? ??? ???? ???????? ??????? ?????.

??? ??? ?????? ???? ???? ????? ?? ??? ??????? ???? ??? ????? ??????? ?????? ?????? ??? ????? ??? ??????? ????? ????? ??? ????????? ?? ?????? ?????? ?????? ?????? ?????. ??? ???? ??????? ??????? ????? ???????: 
   =[Book2]Sheet1!$A$1+1462

   =[Book1]Sheet1!$A$1-1462
?? ??? ????? 1462 ????? ?? ???? ?? ???? ???????.
???? ??? ?????? | ????? ???????

?????

????? ?? ????????? ??? ????? ??????? ???? ????? 1900 ????? ????? 1904 ?? ?? excel? ???? ??? ???? ????????? ???????? ??????? ?? "????? ??????? ? Microsoft":
214348
(http://support.microsoft.com/kb/214348/ )
?? ???? ???? ??????? ??? ???? ????? ????? ??? ????? ????
214365
(http://support.microsoft.com/kb/214365/ )
?? ???? ?????? DATE #NUM! ??? ??? ????? 0-3
213593
(http://support.microsoft.com/kb/213593/ )
??????? ???? ?? ??????? ?? ????? ???? ????? ?????
214239
(http://support.microsoft.com/kb/214239/ )
????? ?????? ?? ??? ?????? ??????? ??????
214058
(http://support.microsoft.com/kb/214058/ )
???? ??????? ??? 1 ???? 1900 ??? ????? ?? Excel
???? ??? ?????? | ????? ???????

???????

???? ???????: 214330 - ????? ??? ??????: 23/???? ??????/1434 - ??????: 2.0
????? ???
  • Microsoft Excel 2013
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 2004 for Mac
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel X ?? Mac
  • Microsoft Office Excel 2008 for Mac
????? ??????: 
kbhowto kbexpertisebeginner kbinfo kbmt KB214330 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214330
(http://support.microsoft.com/kb/214330/en-us/ )
???? ??? ?????? | ????? ???????

????? ???????

 
???? ??? ?????????? ??? ??????