Momwe mungawerengere tsiku lomaliza la mwezi mu Excel

Kuti mupeze tsiku lomaliza la mwezi mu Excel, gwiritsani ntchito ntchitoyi EOMONTH (Kutha kwa Mwezi). Mu version - EOMONTH (kutha kwa mwezi).

1. Mwachitsanzo, tiyeni tiyese kupeza deti la tsiku lomaliza la mwezi uno.

   =EOMONTH(A1,0)

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

Zindikirani: ntchito EOMONTH (EOMONTH) ibweza nambala ya sirio ya tsikulo. Ikani mtundu wa deti kuti muwone bwino.

2. Tsopano tiyeni tiyese kuwerengera tsiku la tsiku lomaliza la mwezi wotsatira.

   =EOMONTH(A1,1)

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

   

3. Titha ngakhale kuwerengera tsiku lomaliza la mwezi lomwe linali miyezi 8 yapitayo pogwiritsa ntchito njira ili pansipa:

   =EOMONTH(A1,-8)

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

   

Zindikirani: Kuwerengera kumapita motere: = 6 – 8 = -2 kapena -2 + 12 = 10, mwachitsanzo, mu October 2011.