Sida loo xisaabiyo maalinta ugu dambeysa ee bisha gudaha Excel

Si aad u hesho taariikhda maalinta ugu dambeysa ee bisha ee Excel, isticmaal shaqada EOMONTH (Dhammaadka Bisha). In nooca - EOMONTH (dhammaadka bisha).

1. Tusaale ahaan, aan isku dayno inaan helno taariikhda maalinta ugu dambeysa ee bisha hadda jirta.

   =EOMONTH(A1,0)

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

noteshaqada EOMONTH (EOMONTH) waxay soo celisaa lambarka taxanaha taariikhda. Codso qaabka taariikhda muujinta saxda ah.

2. Hadda aan isku dayno inaan xisaabino taariikhda maalinta ugu dambeysa ee bisha soo socota.

   =EOMONTH(A1,1)

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

   

3. Waxaan xitaa xisaabin karnaa taariikhda maalinta ugu dambeysa ee bisha oo ahayd 8 bilood kahor anagoo adeegsanayna qaacidada hoose:

   =EOMONTH(A1,-8)

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

   

Fiiro gaar ah: Xisaabinta waxay u dhacdaa sidan: = 6 - 8 = -2 ama -2 + 12 = 10, ie waxa ay soo baxaysaa Oktoobar 2011.