A wasu lokuta, ƙila ba za a tsara abubuwan da suka faru ba don takamaiman kwanan wata, amma an ɗaure su da takamaiman ranar mako na wata da shekara da aka bayar - misali:
- Litinin ta farko na Janairu 2007 ita ce Litinin mafi nauyi a shekara
- Lahadi na biyu a cikin Afrilu 2011 - Ranar Tsaron Sama
- Lahadi ta farko a watan Oktoba 2012 – Ranar Malamai
- da dai sauransu.
Don tantance ainihin ranar da irin wannan rana ta mako ta faɗo, muna buƙatar ƙaramin dabara amma dabara:
=ДАТА(B1;B2;B4*7-6)+ОСТАТ(B3-ДАТА(B1;B2;);7)
a cikin Turanci version zai kasance
=DATE(B1;B2;B4*7-6)+MOD(B3-DATE(B1;B2;);7)
Lokacin amfani da wannan dabarar, ana ɗauka cewa
- B1 - shekara (lambar)
- B2 - lambar wata (lambar)
- B3 - adadin ranar mako (Litinin = 1, Tue = 2, da sauransu)
- B4 - lambar serial na ranar mako da kuke buƙata
Don sauƙaƙawa mai mahimmanci da haɓaka dabarar, godiya da yawa ga waɗanda ake girmamawa SIT daga Dandalin mu.
- Yadda Excel a zahiri ke adanawa da sarrafa ranaku da lokuta
- Ayyukan buƙatar kwanan wata daga PLEX add-on