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

?????? ????????? ?????? ?????????
???? ???????: 214330 - ??? ???????? ???? ????? ????? ??? ???????.
?????? ??? ????? Microsoft Excel 2000 ?? ??? ???????? ???? 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?? ???? ???? ??????? ??? ???? ????? ????? ??? ????? ????
214365 ?? ???? ?????? DATE #NUM! ??? ??? ????? 0-3
213593 ??????? ???? ?? ??????? ?? ????? ???? ????? ?????
214239 ????? ?????? ?? ??? ?????? ??????? ??????
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

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

 

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