XL2000: ?????? ????? ???? DATE # NUM! ??? ????? ???? ????? 0-3

?????? ????????? ?????? ?????????
???? ???????: 214365 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

???????

?? ???? ?????? ??? # NUM! ??? ??? ??? ???? ???? ???? ????? ?????? ???????? ?????. ??? ???? ??????? ?????? ???????

   =DATE(1,7,5)
				
?? ???? ??? # NUM! ???.

?????

???? ??? ??????? ??? ?????? ???????:

  • ?????? ?????? ???? ??????? ?????? ??????? 1904 ??????. - ? -

  • ????? ????? ???? ????? ???????:
      0   00   1900
      1   01   1901
      2   02   1902
      3   03   1903
				
??? "???? ?????" 1904 ??? ???? ??????? ????????? ?? Microsoft Excel ???????? ??? ??????? ?????? ???? ?? ???????? ???? ?? ??????? ??? ???????. ????? ??? ?????? ??? ??????? ?? Microsoft Excel.

???? ??????

?????? ??? ??? ???????? ?????? ????? ?????? ??? ??????? ?? ????? ????? ???? ?? ?? ????? 1904. ??? ???? ??????? ????? ?? ?????? ???????
   =DATE(1,7,5)
				
?????? ?????? ???????:
   =DATE(2001,7,5)
				
?????? ??? ?????? ????? ????? ???? ????? ??? ?????? ?? ????? # NUM! ???? ???.

??????? ????

?? Microsoft Excel? ????? ??????? ?? ?? ?????? ???????? ???????.

   Date system        First day is      Default date system in
   ----------------------------------------------------------------------

   1900 Date System   January 1, 1900   Microsoft Excel for Windows
                                        Microsoft Excel for Windows NT

   1904 Date System   January 1, 1904   Microsoft Excel for the Macintosh
				
?????? ???? ??????? ?????? ????? ???? ??????? ???????:

  1. ?? ??????? ?????? ???? ??? ??????. ???? ??? ????? ??????? ??????.
  2. ???? ?????? ???? ???????? ???? ??????? 1904 ???????? ??? ???? ??????? ? ???????? "???? ?????" 1900 ?? ?????? ????? ???? ????????.
  3. ???? ??? ?????.
??? ??????? ?????? ?????? ????? ???????? ?????? ???? ??????? ????? ??? ???? ?? ????? ????? ?????? ?? ??????? ?? ????? 20th (19xx). ???? ??? ?????? "???? ?????" 1904 ???????? ??? 1 ?????? 1904 ???? ?????? ?? ???? ????? ????? ??? ?? ??? ?? 1904. ??? ???? ??????? ??? ??? ??????? ???????.
                      Result when using   Result when using
   Formula            1900 Date System    1904 Date System
   ----------------------------------------------------------------
   =DATE(0,1,1)       1/1/1900            #NUM!

   =DATE(1,7,5)       7/5/1901            #NUM!

   =DATE(1902,8,12)   8/12/1902           #NUM! (since year < 1904)

   =DATE(4,3,31)      3/31/1904           3/31/1904
				

???????

???? ???????: 214365 - ????? ??? ??????: 02/???? ??????/1435 - ??????: 3.0
????? ???
  • Microsoft Excel 2000 Standard Edition
????? ??????: 
kbnosurvey kbarchive kbmt kbprb KB214365 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????214365

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

 

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