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

?????? ????????? ?????? ?????????
???? ???????: 214019 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

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

??????? ????

???? ??????? ???????? ?? ??? Excel ???????? ??? ???????? ???????? ???? ?? 1582 ??????? ??????? ?????? ???. ?? ??? ??????? ???? ?????? ??????? ???? ?? ??????? ?????? ??????? ????????? ??? ???.

?? ??????? ????????? ??? ????? ????? ?? 365 ????. ??? ????? ??????? ????? ???? (????? ??????? ????? ????? ??? ????? ??? ?????) ?????? 365.25635 ????? "??? ?????" ?? 366 ??? ??????? ???? ??? ?? ???? ????? ??? ????? ?????? ?? ????? ????? ?????? (???? ?????). ?? ????? ???? ??? ?????? ???????? 4 ???? ?????: ??? ???? ??????? 1988 ? 1992 ? 1996 ?? ??????? ???????.

??? ???? ?? ???? ???? ??? ???? ???? ??? ?? ????. ?????? ??? ???? ??????? ???????? ??? ?? ??? ???? ???? ??????? ???????? 100 (??? ???? ??????? 1900) ??? ????? ??? ??? ??? ???? ???? ??????? ???????? 400.

????? ?????? ??????? ??????? ???? ??????? ???????:
1700? 1800? 1900? 2100? 2200? 2300? 2500? 2600
??? ????? ???? ??????? ???????? ? 100 ???? ??? ?????? 400.

??????? ??????? ?? ??????? ???????:
1600? 2000? 2400
???? ????? ??? ?? 100 ? 400.

??? ??????? Microsoft Excel ??????? ?? Excel 97 ?????? ??????? ??? ?? 1900 ??? 2078 ??? ??? 1900 ???? ?????? ????????? 100/400 ?? ??????? ??????? ?? Microsoft Excel. ??? ???? ??? ?????? ?? ????? ?????? ????? Microsoft Excel ??? 1900 ???? ?????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ????? Microsoft":
214058???? ??????? ??? 1 ???? 1900 ??? ????? ?? Excel

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

?????? ?? ??? ???? ??? ??? ?????? ???? ??? ???????:
  1. ?? ???? ?????? ???? ????? ??? 4 ????????? ????? ??? ?????? 2. ????? ????? ??? ?????? 5.
  2. ?? ???? ?????? ???????? 100 ?????? ????? ??? ?????? 3. ????? ????? ??? ?????? 4.
  3. ??? ??? ???? ??????? ???????? ????? 400? ????? ??? ?????? 4. ????? ????? ??? ?????? 5.
  4. ????? ?? ??? ????? (????? 366 ????).
  5. ????? ??? ??? ????? (????? 365 ????).

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

?????? ?????? ??????? ?????? ?? ??? ??? ??? ????? ??? ?? ??????? ?? ???? (?? ??? ??????? ?????? A1) ??? ?????:
=IF(OR(MOD(A1,400)=0,AND(MOD(A1,4)=0,MOD(A1,100)<>0))? "??? ?????"? "?? ??? ?????")
   If the value in cell A1 is this        The formula returns
   ----------------------------------------------------------
   1992                                   Leap Year
   2000                                   Leap Year
   1900                                   NOT a Leap Year
				

???????

???? ???????: 214019 - ????? ??? ??????: 11/????? ???????/1434 - ??????: 5.0
????? ???
  • Microsoft Office Excel 2007
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Excel 2001 ?? Macintosh
  • Microsoft Excel 2000 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
  • Microsoft Excel 97 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2010
????? ??????: 
kbhowto kbmt KB214019 KbMtar
????? ????
???: ??? ????? ??? ??????? ???????? ????? ?????????? ??????? ?????? ??? ??????? ?? ??? ??????? ?? ??????? ??? ??? ?? ???? ????????? ???? ??????? ???????(CTF) ?? ?? ???? ????? ????. ???? ?? ???? ?????????? ??? ???????? ???????? ???? ??? ?? ???????? ??????? ?? ??? ??????? ???????? ?? ??? ??????? ??????? ??? ?????? ?? ?????? ??? ???? ???????? ???????? ?? ????? ??????? ????? ????? ??????. ??? ?? ???????? ???????? ?? ????? ??? ????? ?? ???????? ?? ???? ????? ?? ?????. ?????? ??? ???? ?????????? ???? ?????? ?? ??? ????? ?? ??? ??? ?? ??????? ?? ??? ????? ?? ???? ????? ????? ?? ????? ??????? ???? ?? ???????? ?? ??? ???????.
???? ??? ????? ??????? ?????? ??????????214019

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

 

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