Uma udinga ikhalenda eshidini le-Microsoft Excel, khona-ke unezindlela eziningi ezihlukene - kusukela ekufakeni kanzima amadethi mathupha ukuya ekuxhumeni amakhalenda azivelelayo kusukela ku-add-ons namamakhro ahlukahlukene. Enye inketho ukusebenzisa ikhalenda yendawo yonke yanoma iyiphi idethi usebenzisa ifomula yohlu olulodwa kuphela (nakuba kusabisa kakhulu).
Ukuze uyisebenzise, dala okungenalutho eshidini kanje:
Idethi kuseli B2 ingaba yinoma yini, inyanga nonyaka kuphela okubalulekile lapha. Amaseli kububanzi B3:H3 angaqukatha amagama ezinsuku zeviki kunoma iyiphi ifomethi efanelekile.
Manje khetha ububanzi B4:H9 bese ufaka ifomula elandelayo lapho:
=ЕСЛИ(МЕСЯЦ(ДАТА(ГОД(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)
Enguqulweni yesiNgisi kuzoba:
=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)
Bese ushaya inhlanganisela Ctrl + Shift + Fakaukufaka le fomula njengefomula yamalungu afanayo. Wonke amaseli akhethiwe kufanele agcwaliswe ngezinsuku zenyanga ezishiwo ku-B2:
Okusele nje ukupholisha ukubukeka ngokwengeza ukufometha nokufihla usuku esihlokweni esithi B2 kanye nenyanga nonyaka kuwo wonke amaseli usebenzisa iwindi. Fometha Amaseli (Ctrl+1):
Manje, ngokushintsha idethi kuseli B2, sizothola ikhalenda elilungile lanoma iyiphi inyanga ekhethiwe yanoma yimuphi unyaka ngokuvumelana nefomula yethu. Cishe ikhalenda elingapheli 😉
- Ungaxhuma kanjani ikhalenda le-popup eshidini le-excel
- Ukufakwa kwedethi esheshayo nesikhathi nesengezo se-PLEX
- I-Excel isebenza kanjani namadethi nezikhathi
- Ukungena okusheshayo kwedethi nesikhathi ngaphandle kwezihlukanisi