Idan kuna buƙatar kalanda akan takardar Microsoft Excel, to kuna da hanyoyi daban-daban - daga shigar da kwanan wata da hannu da ƙwazo zuwa haɗa kalanda masu tasowa daga add-ons da macros daban-daban. Wani zaɓi shine aiwatar da kalandar duniya don kowace rana ta amfani da tsari ɗaya kawai (ko da yake yana da ban tsoro daga al'ada).
Don amfani da shi, ƙirƙirar blank akan takardar kamar haka:
Kwanan wata a cikin tantanin halitta B2 na iya zama wani abu, kawai watan da shekara suna da mahimmanci a nan. Kwayoyin da ke cikin kewayon B3:H3 na iya ƙunsar sunayen kwanakin mako a kowane tsari mai dacewa.
Yanzu zaɓi kewayon B4:H9 kuma shigar da dabarar a can:
=ЕСЛИ(МЕСЯЦ(ДАТА(ГОД(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)
A cikin harshen Ingilishi zai kasance:
=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)
Sannan danna hade Ctrl + Shigar + Shigardon shigar da wannan dabara a matsayin tsarin tsararru. Dole ne a cika dukkan sel da aka zaɓa da kwanakin watan da aka ƙayyade a cikin B2:
Abin da ya rage shi ne a goge kamannin ta ƙara tsarawa da ɓoye ranar a cikin taken B2 da wata da shekara a cikin sauran sel ta amfani da taga. Tsara Kwayoyin (Ctrl+1):
Yanzu, ta hanyar canza kwanan wata a cikin tantanin halitta B2, za mu sami madaidaicin kalanda na kowane watan da aka zaɓa na kowace shekara bisa ga tsarin mu. Kusan kalandar har abada 😉
- Yadda ake haɗa kalanda popup zuwa takardar Excel
- Saurin kwanan wata da shigarwar lokaci tare da ƙari na PLEX
- Yadda Excel ke aiki tare da kwanakin da lokuta
- Saurin kwanan wata da shigarwar lokaci ba tare da masu rarrabawa ba