Txhawm rau kom tau txais hnub kawg ntawm hnub kawg ntawm lub hli hauv Excel, siv cov haujlwm EOMONTH (End of Month). In the version – EOMONTH (lub hli kawg).
- Piv txwv li, cia peb sim kom tau txais hnub ntawm hnub kawg ntawm lub hli tam sim no.
=EOMONTH(A1,0)
=КОНМЕСЯЦА(A1;0)
Ceeb toom: ua haujlwm EOMONTH (EOMONTH) xa rov qab tus lej xov tooj ntawm hnub. Siv lub hnub hom rau cov zaub kom raug.
- Tam sim no cia peb sim suav hnub ntawm hnub kawg ntawm lub hli tom ntej.
=EOMONTH(A1,1)
=КОНМЕСЯЦА(A1;1)
- Peb tuaj yeem suav hnub kawg ntawm ib hlis uas yog 8 lub hlis dhau los siv cov qauv hauv qab no:
=EOMONTH(A1,-8)
=КОНМЕСЯЦА(A1;-8)
Nco ntsoov: Cov kev suav mus ib yam li no: = 6 - 8 = -2 los yog -2 + 12 = 10, piv txwv li tig tawm lub Kaum Hlis 2011.