Ungalubala kanjani usuku lokugcina lwenyanga ku-Excel

Ukuze uthole idethi yosuku lokugcina lwenyanga ku-Excel, sebenzisa umsebenzi EOMONTH (End of Month). In the version – EOMONTH (ukuphela kwenyanga).

1. Isibonelo, ake sizame ukuthola idethi yosuku lokugcina lwenyanga yamanje.

   =EOMONTH(A1,0)

   =КОНМЕСЯЦА(A1;0)

Note: umsebenzi EOMONTH (EOMONTH) ibuyisela inombolo ye-serial yedethi. Sebenzisa ifomethi yedethi ukuze uthole isibonisi esifanele.

2. Manje ake sizame ukubala idethi yosuku lokugcina lwenyanga elandelayo.

   =EOMONTH(A1,1)

   =КОНМЕСЯЦА(A1;1)

   

3. Singakwazi nokubala idethi yosuku lokugcina lwenyanga olwaluyizinyanga eziyi-8 ezedlule sisebenzisa ifomula engezansi:

   =EOMONTH(A1,-8)

   =КОНМЕСЯЦА(A1;-8)

   

Qaphela: Izibalo zihamba kanje: = 6 – 8 = -2 noma -2 + 12 = 10, okusho ukuthi kuzophuma ngo-Okthoba 2011.