Nthawi zina, zochitika sizingakonzedwe tsiku linalake, koma zimamangirizidwa ku tsiku linalake la sabata la mwezi ndi chaka choperekedwa - mwachitsanzo:
- Lolemba loyamba la Januware 2007 ndi Lolemba lolemera kwambiri pachaka
- Lamlungu lachiwiri mu April 2011 - Tsiku la Chitetezo cha Air
- Lamlungu loyamba mu Okutobala 2012 - Tsiku la Aphunzitsi
- etc.
Kuti tidziwe tsiku lenileni limene tsiku loterolo la sabata limachitikira, tifunika njira yaying'ono koma yovuta:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
mu Chingelezi chidzakhala
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
Mukamagwiritsa ntchito formula iyi, zimaganiziridwa kuti
- B1 - chaka (nambala)
- B2 - nambala ya mwezi (nambala)
- B3 - nambala ya tsiku la sabata (Mon=1, Tue=2, etc.)
- B4 - nambala ya serial ya tsiku la sabata lomwe mukufuna
Pakufewetsa kwakukulu ndikusintha kwa fomula, zikomo kwambiri kwa olemekezeka KUKHALA kuchokera ku Forum yathu.
- Momwe Excel imasungira ndikusintha masiku ndi nthawi
- Ntchito ya NeedDate kuchokera ku PLEX yowonjezera