Ho fumana letsatsi la letsatsi la ho qetela la khoeli ho Excel, sebelisa ts'ebetso KHOHLOOA (End of Month). In the version – KHOHLOOA (qetellong ea khoeli).
- Mohlala, ha re lekeng ho fumana letsatsi la ho qetela la khoeli ea hona joale.
=EOMONTH(A1,0)
=КОНМЕСЯЦА(A1;0)
Hlokomela: mosebetsi KHOHLOOA (EOMONTH) e khutlisa nomoro ea seriale ea letsatsi. Sebelisa mokhoa oa letsatsi bakeng sa pontšo e nepahetseng.
- Joale a re lekeng ho bala letsatsi la ho qetela la khoeli e tlang.
=EOMONTH(A1,1)
=КОНМЕСЯЦА(A1;1)
- Re ka bala le letsatsi la ho qetela la khoeli le neng le le likhoeling tse 8 tse fetileng re sebelisa foromo e ka tlase:
=EOMONTH(A1,-8)
=КОНМЕСЯЦА(A1;-8)
Hlokomela: Lipalo li tsamaea ka tsela e tjena: = 6 – 8 = -2 kapa -2 + 12 = 10, ke hore, ka October 2011.