Mune zvimwe zviitiko, zviitiko zvingave zvisina kurongerwa zuva chairo, asi zvakasungirirwa kune rimwe zuva revhiki remwedzi wakapihwa uye gore - semuenzaniso:
- Muvhuro wekutanga waNdira 2007 ndiwo Muvhuro unorema kwazvo wegore
- Svondo yechipiri muna Kubvumbi 2011 - Air Defense Day
- Svondo yekutanga muna Gumiguru 2012 - Zuva reVadzidzisi
- etc.
Kuti tizive zuva chairo rinowira zuva rakadaro revhiki, tinoda diki asi rine hunyanzvi fomula:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
mushanduro yeChirungu zvichave
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
Paunenge uchishandisa iyi formula, inofungidzirwa kuti
- B1 - gore (nhamba)
- B2 - mwedzi nhamba (nhamba)
- B3 - nhamba yezuva revhiki (Mon=1, Tue=2, nezvimwewo)
- B4 - serial nhamba yezuva revhiki raunoda
Nekurerutsa kwakakosha uye kuvandudzwa kweformula, vazhinji kutenda kune vanoremekedzwa gara kubva kuForamu yedu.
- Maitiro eExcel anochengetedza uye anogadzirisa misi nenguva
- NeedDate basa kubva kuPLEX add-on