Haeba u hloka almanaka leqepheng la Microsoft Excel, joale u na le mekhoa e mengata e fapaneng - ho tloha ka ho kenya matsatsi ka hloko ka letsoho ho ea ho hokahanya lialmanaka tsa pop-up ho tsoa ho li-add-on le li-macro tse fapaneng. Kgetho e 'ngoe ke ho kenya ts'ebetsong almanaka ea bokahohle bakeng sa letsatsi leha e le lefe ka ho sebelisa mokhoa o le mong feela (le hoja e le ntho e tšosang haholo)
Ho e sebelisa, etsa sekheo pampiring e kang ena:
Letsatsi ka seleng ea B2 e ka ba eng kapa eng, khoeli le selemo feela ke tsa bohlokoa mona. Lisele tse lethathamong la B3: H3 li ka ba le mabitso a matsatsi a beke ka mokhoa ofe kapa ofe o loketseng.
Joale khetha mofuta oa B4: H9 'me u kenye foromo e latelang moo:
=ЕСЛИ(МЕСЯЦ(ДАТА(ГОД(B2);МЕСЯЦ(B2);1)) <>МЕСЯЦ(ДАТА(ГОД(B2);МЕСЯЦ(B2);1)- (ДЕНЬНЕД(ДАТА(ГОД(B2);МЕСЯЦ(B2);1);2)-1) +{0:1:2:3:4:5}*7+{1;2;3;4;5;6;7}-1);» «; ДАТА(ГОД(B2);МЕСЯЦ(B2);1)- (ДЕНЬНЕД(ДАТА(ГОД(B2);МЕСЯЦ(B2);1);2)-1) +{0:1:2:3:4:5}*7+{1;2;3;4;5;6;7}-1)
Phetolelong ea Senyesemane e tla ba:
=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1)) <>MONTH(DATE(YEAR(B2),MONTH(B2),1)- (WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1) +{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””, DATE(YEAR(B2),MONTH(B2),1)- (WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1) +{0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)
Ebe o otla motsoako Ctrl + Shift + Kenaho kenya foromo ena joalo ka mokhoa o hlophisitsoeng. Lisele tsohle tse khethiloeng li tlameha ho tlatsoa ka matsatsi a khoeli a boletsoeng ho B2:
Se setseng ke ho bentša chebahalo ka ho eketsa fomete le ho pata letsatsi sehloohong sa B2 le khoeli le selemo liseleng tse ling tse sebelisang fensetere. Fomata Lisele (Ctrl+1):
Joale, ka ho fetola letsatsi ho sele ea B2, re tla fumana almanaka e nepahetseng bakeng sa khoeli efe kapa efe e khethiloeng ea selemo leha e le sefe ho latela foromo ea rona. Hoo e batlang e le almanaka e sa feleng 😉
- Mokhoa oa ho hokahanya almanaka ea popup ho leqephe la Excel
- Ho kenya letsatsi le nako ka potlako ka kenyelletso ea PLEX
- Excel e sebetsa joang le matsatsi le linako
- Keno e potlakileng ea letsatsi le nako ntle le likarohano