Ngati mukufuna kalendala pa pepala la Microsoft Excel, ndiye kuti muli ndi njira zambiri zosiyanasiyana - kuyambira pakulowa movutikira pamanja mpaka kulumikiza makalendala a pop-up kuchokera pazowonjezera zosiyanasiyana ndi ma macros. Njira ina ndikukhazikitsa kalendala yapadziko lonse lapansi yatsiku lililonse pogwiritsa ntchito njira imodzi yokha (ngakhale yowopsa mwachizolowezi).
Kuti mugwiritse ntchito, pangani chopanda kanthu pa pepala monga chonchi:
Tsiku mu selo B2 likhoza kukhala chirichonse, mwezi ndi chaka chokha ndizofunika pano. Maselo omwe ali mu B3: H3 akhoza kukhala ndi mayina a masiku a sabata mumtundu uliwonse woyenera.
Tsopano sankhani mtundu wa B4:H9 ndikulowetsamo zotsatirazi:
=ЕСЛИ(МЕСЯЦ(ДАТА(ГОД(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)
M'Chingerezi zikhala:
=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)
Kenako kugunda kuphatikiza Ctrl + Shift + Lowanikuti mulowetse fomuyi ngati njira yotsatsira. Maselo onse osankhidwa ayenera kudzazidwa ndi masiku a mwezi omwe atchulidwa mu B2:
Chotsalira ndikupukuta mawonekedwe powonjezera masanjidwe ndi kubisala tsiku pamutu B2 ndi mwezi ndi chaka m'maselo ena onse pogwiritsa ntchito zenera. Maselo Opanga (Ctrl+1):
Tsopano, posintha tsiku mu selo B2, tidzalandira kalendala yolondola ya mwezi uliwonse wosankhidwa wa chaka chilichonse malinga ndi ndondomeko yathu. Pafupifupi kalendala yosatha 😉
- Momwe mungalumikizire kalendala yotulukira ku Excel sheet
- Kulowetsa mwachangu komanso nthawi ndi chowonjezera cha PLEX
- Momwe Excel imagwirira ntchito ndi masiku ndi nthawi
- Kulowa mwachangu komanso nthawi popanda olekanitsa