?????? ???? EOMONTH ??? ????? ??? ??????? ?? ??????

?????? ????????? ?????? ?????????
???? ???????: 179545 - ??? ???????? ???? ????? ????? ??? ???????.
??? ????? ??? ???????. ????? "??? ??" ??? ??? ??????? ??? ????.
????? ???? | ?? ????

???????

??? ??? ?????? ?????? EOMONTH ?????? ????? ?????? ?? ??? ?? ?????? ????? ?? ??? ?????? ??? ??? ?? ????? ??????.

??? ???? ??????? ?? ?????? EOMONTH ?????? 3/1/???? (1 ???? ????) ????? ?? ???? (?? ?????? ????) ???? ??? ????.

?????

???? ??? ??????? ??? ????? ???? ??? ??????? ?? ??? EOMONTH ?????? ?? ?????? ???????:
  • ??????? ?? ??????. - ? -

  • ??????? ?? ??? ??? ??? ???? ???????? ?????? 400 ? ??? ???? ??????:
    2100 ? 2200 ? 2300 ? 2500 ? 2600 ? 2700 ? 2900 ? 3000
??????: ??? ??????? ?? ???? ??? ??? ????? ?? ??? 1900 ?? 2000.

???? ??????

???? ??? ????? ?? ???? ?????? EOMONTH ????? ?? ????? ?????, ????? ????? ????? ???? ??? ????? ?? ??????? ???? ??? ??????? ?????? ?????? EOMONTH ??? ?? ??? ??????? ?? ????? ?????. ??? ???? ?????? ?????? ??????? ?????? ??? ???? ??????:
?1: 1/1/????
a2: =eomonth(a1,1)
?????? ?? ?????? A2 ????? 1 3 ???? ? ????? ??? ????. ??? ???? ??? ??? ?????? ??????
A1: 1 1 ????
A2: =IF(DAY(EOMONTH(A1,1))=1,EOMONTH(A1,1)-1,EOMONTH(A1,1))
???? ?????? ?????? ??????? (2/28/????) ??? ????? ?? ?? ??? ??????? ?? ?????? ????? ????? ??? ???? ???????? ?????? 400.

??? ????? ??? ??????:
??? ??? ??? ????? ????? 1? ????? ???? ????? ????? ??? ??? ?? ????? ???????. ????? ????? ???? ????? ????? ??????? ???????.

?????

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

??????? ????

?????? EOMONTH ???? ??? ??????? ?? Analysis ToolPak ? ???? ?? ??????? ????? ??? ??? ?? ???. ??? ???? ??????? ??? ??? ???? ?? ????? ????? ?????? ?? ??? ??? ???? ?? ????? ????? ?????? ?????? ???????:
=eomonth(today(),6)
??? ??? ????? 1/13/98? ?????? ???? ?????? 31 7 98: ????? ?????? ?? ??? ??? ???? ?? ?????.

???? ??? ??????? ??????? ?? ??? ??????? ??? ??? ????? ?????? EOMONTH ????? ?? ?????? ????? ????? ??? ??? ????? ??? ???? ??????:
?1 1/1/2000 ?1:: =eomonth(a1,1)
a2: 1 1 ???? ?2: =eomonth(a2,1)
?3: 1 1 2200 ?3: =eomonth(a3,1)
?4: 1 1 2300 ?4: =eomonth(a4,1)
a5: 1 1 2400 b5: =eomonth(a5,1)
???? ????? ?? ??????? ? "?1" ? "B5 ??????? ??????? (2/29/2000 ? 29 2 2400) ???? ???? ???????? ?? ??? ????? ???? ???? ???????? 400.

???? ????? ?? ??????? B2, B3 ? B4 ??? ???? ????? (3/1/???? ? 3/1/2200 1 3 2300) ???? ???? ???????? ?? ??? ????? ??? ???? ???????? ?????? 400.

???????

???? ???????: 179545 - ????? ??? ??????: 09/???? ??????/1435 - ??????: 2.0
????? ???
  • Microsoft Excel 97 Standard Edition
  • Microsoft Excel 98 ?? Macintosh
????? ??????: 
kbnosurvey kbarchive kbmt kbbug kbpending KB179545 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????179545

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

 

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