XL: 1900 ???? ????? ????? ???? ????? 1904

?????? ????????? ?????? ?????????
???? ???????: 180162 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

????? Microsoft Excel ???????? ????? ???: ???? ????? 1900 ? ???? ????? 1904. ???? ??? ??????? ??????? ????? ??????? ???? ?? ??????? ??? ??????? ???????? ???? ?????? ????? ????? ??? ??????.

??????? ????

???? ????? 1900

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

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

???? ????? 1904

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

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

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

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

   1900 date system   35981
   1904 date system   34519
				
????? ??? ??????? ????? ??????? ??? 1,462; ?? ????? ???????? ??????? ?? "???? ?????" 1900 ?? ????? ?????? 1,462 ???? ?? ????? ???????? ??????? ??? ?? ???? ????? 1904. ?????? 1,462 ?????? ???? ????? ? ??? ???? (??? ???? ????? ??? ?? ???).

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

?? Microsoft Excel? ?? ???? ???? ?????? ?? ????? ?????? ??????? ??? ??? ?? ??? ?????? ??????. ????? ????? ???? ??????? ????? ?????? ??????? ???????:
  1. ???? ?? ?? ???????? ??? ??????.
  2. ??? ??????? ????? (?? ??????? "?????" ?? Excel 2001 ?? Mac) ? ???? ??? "??????" ?? "???????". ?? ???? ??? ????? ??????? ????.
  3. ???????? ???? ????? 1900 ?? ?????? ? ???? ?????? ????? ???? ???????? ???? ????? 1904. ???????? ???? ????? 1904 ?? ?????? ? ???? ?????? ???? ????????.
  4. ???? ??? ?????.
???? ??? ??? ??? ?????? ???? ??????? ?????? ???? ????? ?????? ??? ?????? ????? ???????? ?????? ???? ????? ? ??? ????. ?????? ??? ??????? ??? ????? ???????? shifted ???? ???? "????? ???????? ?????" ?? ??? ???????.

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

??????? ?????? ????? ????? ???, ?? ????? ????? ??? ??? ?? ??? ???????? ??? ????????. ????? ???? ?? ???? ????? ???????? ?????? ???? ????? ? ??? ????.

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

    ??? ??? ??????? ?? 6 ?????, 2002. ???? ?? ??????? ????? ??????? ??? ???? ? ??? ????? ?? ?????? 3 ??? Book2 ?????? ???? ????? 1904.
  6. ?? Book2 ? ???? ??????? 5 ????? 1998. ??? ?????? ???? ????? ??? ??????? ?? ???? ??? ??? ??? ??????? ?????.
  7. ??????? ??? Book1 ??? ???? ?? ???? ??? ??? ?? ??????? ?????.
??? ??? ??????? ?? 4 ????? 1994. ??? ?? ?? ????? ?????? ???? ????? ? ??? ???? ??? Book1 ?????? ???? ????? 1900.

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

??? ??? ????????? ?? ?? ??? ???????? ??? ???????? ?? ??? ??? ?????? ???? ??????? ?????? ???? ????? ?????? ??? ?????? ?? ???? ????? ???????? ?????? ???? ????? ? ??? ????. ????? ????? ???????? shifted ?????? ??????? ???????:
  1. ?? ?? ???? ?????? ???? ???? 1462.
  2. ??? ??????. ?? ??????? ????? ? ???? ??? ???.
  3. ??? ??????? ???? ????? ??? ???????? shifted. ?? ??????? ????? ? ???? ??? ??? ???.
  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. ???? ??? ?????.
??? ??? ??????? ??? ??? ????? ???? ???????? shifted.

??? ??? ?????? ???? ???? ????? ?? ???? ??? ???? ??????? ???? ?? ?????? ?????? ?????? ??? ????? ???? ??????? ???????? ????? ????? ??? ????? ?????? ?????? ??????? ?????? ??? ???? ??????:
   =[Book2]Sheet1!$A$1+1462
				
   =[Book1]Sheet1!$A$1-1462
				
?? ????? ???? 1,462 ????? ?? ???? ?? ???? ???????.

?????? ?? ????????? ?? "????? ??????? ?? Microsoft

"????? ??????? ?? Microsoft" ????? ??? ??? ???????? ???? ????? ??? ??????? ??? ??????? ???? ????? 1900 ? ???? ????? 1904 ?? Microsoft Excel. ??? ??? ??? ???????? ??? ???:
274277MacXL: ?????? ???? ?????? ???? ????? ?????? ??? ????? ?????

214318XL2000: ?????? ???? ?????? ???? ????? ?????? ??? ????? ?????

177172XL97: ?????? ???? ?????? ???? ????? ?????? ??? ????? ?????

175753XL: ?????? ????? ???? DATE # NUM! ??? ????? ???? ????? 0-3

157035XL: ?? ??????? ??????? ??????? ?? ????? ??? ???? ????? ???? ????

156987XL: ????? ???? ??? ????? ??????? ??????

???????

???? ???????: 180162 - ????? ??? ??????: 03/????/1428 - ??????: 2.3
????? ???
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 95 Standard Edition
  • Microsoft Excel 95a
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 5.0c
  • Microsoft Excel 5.0 Standard Edition
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 98 ?? Macintosh
  • Microsoft Excel 5.0 ?? Macintosh
  • Microsoft Excel 5.0a ?? Macintosh
????? ??????: 
kbmt KB180162 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????180162
????? ??????? ?? ????? ???? ?? ????? ???????
?? ????? ????? ?????? ???? ???? ???? ??? ??????? ??? ?? ? ?? ??? ??????? Microsoft ??? ????? ??? ??????? ????? ?????? ?????

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

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com