Kwezinye izimo, imicimbi ingase ingahlelelwe idethi ethile, kodwa iboshelwe osukwini oluthile lweviki lwenyanga nonyaka onikeziwe - isibonelo:
- uMsombuluko wokuqala kaJanuwari 2007 unguMsombuluko onzima kakhulu onyakeni
- NgeSonto lesibili ngo-Ephreli 2011 - Usuku Lokuvikela Emoyeni
- ISonto Lokuqala ngo-Okthoba 2012 - Usuku Lothisha
- njll
Ukuze sinqume usuku oluqondile oluwela ngalo usuku olunjalo lweviki, sidinga ifomula encane kodwa ekhohlisayo:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
enguqulweni yesiNgisi kuzoba njalo
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
Uma usebenzisa le fomula, kucatshangwa ukuthi
- B1 - unyaka (inombolo)
- B2 - inombolo yenyanga (inombolo)
- B3 – inombolo yosuku lweviki (Mon=1, Tue=2, njll.)
- B4 - inombolo ye-serial yosuku lwesonto oludingayo
Ngokwenza lula okubalulekile kanye nokuthuthukiswa kwefomula, sibonga kakhulu kwabahlonishwayo HLALA kusuka kuForamu yethu.
- I-Excel igcina kanjani futhi isebenza kanjani izinsuku nezikhathi
- Umsebenzi we-NeedDate ovela kusengezo se-PLEX