01 na 01
Kira kwanan wata ko kwanakin farawa tare da aikin aikin
Ayyukan EOMONTH, takaice don Ƙare Watan Watan aiki, ana iya amfani dasu don lissafin kwanan wata balaga ko kwanan wata na zuba jari ko aikin da ya ƙare a ƙarshen watan.
Bugu da ƙari, aikin zai dawo lambar lamba don rana ta ƙarshe ta watan don yawan adadin watanni kafin ko bayan kwanan fara kwanan wata.
Ayyukan suna da kama da aikin EDATE , sai dai lokacin da aka dawo EDATE wanda yake daidai da watanni kafin ko bayan ranar farawa, yayin da EOMONTH yana ƙara yawan kwanaki don isa ƙarshen watan.
Hanyoyin Sakamakon Ayyukan Kasuwanci da Magana
Haɗin aikin aiki yana nufin layout na aikin kuma ya haɗa da sunan aiki, shafuka, rabuɗɗun takaddama, da muhawara .
Hadawa don aikin EOMONTH shine:
= KASHI (Farawa, Watanni)
Fara_date - (da ake buƙatar) kwanan wata na aikin ko lokaci a cikin tambaya
- wannan jayayya na iya zama kwanan wata da aka shigar a cikin aikin, ko kuma mai suna mai suna ko ƙididdigar salula zuwa wuri na bayanan a cikin takardun aiki.
- idan tantancewar salula ya shiga don kwanan farawa yana zuwa ɓataccen ɗakin, aikin yana ɗaukar tantanin tantanin halitta yana da nau'in adadin lambar zero kuma yana ƙayyade ƙarshen kwanan watanni da yawa bayan ranar ƙaddarar ranar Janairu 0, 1900 - kamar yadda aka nuna a jere na 9 na misali.
Watanni - (buƙatar) yawan watanni kafin ko bayan Fara_date
- wannan jayayya na iya zama kwanan wata da aka shigar a cikin aikin ko wani suna mai suna ko ƙididdigar salula zuwa wurin da aka sanya bayanai a cikin takardar aiki;
- Matsakaici masu kyau suna samar da kwanakin nan - jere 8 a cikin hoton da ke sama;
- ƙananan dabi'u kwanakin da suka gabata - jere 3 a cikin hoto a sama;
Idan watanni ba adadin ba ne, an cire shi (an cire sashin ƙaddara) - kamar yadda aka nuna a jere na 8 a cikin hoton da ke sama inda shekaru 12.25 aka ƙaddara zuwa lamba 12;
Kuskuren Kima ya dawo
Aikin ya dawo #VALUE! kuskure kuskure idan:
- Fara_date ba ranar kwanan wata ba ne - kamar yadda aka nuna a jere 4 a cikin hoton da ke sama, tun 2/30/2016 (Fabrairu 30, 2016) wata rana ne mara kyau;
- an yi amfani da nassoshin tantanin salula don Magana akan gardama na gaba game da tantanin halitta wanda ke dauke da dabi'un Boolean , bayanan rubutu, ko dabi'u mara kyau .
Aikin ya dawo #NUM! kuskure kuskure idan:
- Fara_date shine kafin Janairu 1, 1900;
- Farawa na jinkirin watanni yana samar da wata rana kafin Janairu 1, 1900.
Kwalolin Kayan aiki na Excel
A cikin hoton da ke sama, aikin na EOMONTH yana aiki don ƙarawa da kuma cire wasu adadin watanni zuwa ranar Janairu 1, 2016.
Bayanan da ke ƙasa ya rufe matakan da ake amfani dashi don shigar da aikin zuwa cikin cell B3 na takardar aiki
Shigar da Halin KYAU
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: = KUMA (A3, C2) zuwa cikin cell C3;
- Zabi aikin da kuma muhawara ta amfani da akwatin maganganu na EOMONTH.
Kodayake yana yiwuwa a rubuta aikin gaba ɗaya ta hannu, mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki.
Matakan da ke ƙasa da rufe shigar da aikin EOMONTH da aka nuna a cikin tantanin halitta B3 a cikin hoton da ke sama ta amfani da akwatin maganganun aikin.
Tun da darajar da za a shigar don maganganun watanni ba daidai ba ne (-6) kwanan wata a cikin sel B3 zai kasance a baya fiye da kwanan farawa.
Misalin Misalin - Sashin Saukewa
- Danna kan tantanin halitta B3 - don sa shi tantanin halitta;
- Danna kan Rubutun hanyoyin shafin rubutun;
- Danna kwanan wata da ayyukan lokaci don buɗe jerin abubuwan da aka sauke aikin;
- Danna kan KASHI a cikin jerin don kawo akwatin maganganu na aikin;
- Danna maɓallin Start_date a cikin akwatin maganganu;
- Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin salula a cikin akwatin maganganun a matsayin shaida na Start_date ;
- Danna jerin kwanan watan a cikin akwatin maganganu;
- Danna sel B2 a cikin takardun aiki don shigar da wannan tantanin salula a cikin akwatin maganganu a matsayin Magana na watanni ;
- Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki;
- Ranar 7/31/2015 (Yuli 31, 2016) - ya bayyana a cikin tantanin halitta B3 wadda ita ce ranar ƙarshe ta wata da ta kasance watanni shida kafin ranar farawa;
- Idan lamba, irin su 42216, ya bayyana a tantanin halitta B3 yana iya yiwuwa tantanin halitta yana da Tsarin Tsarin Mulki yana amfani da shi. Dubi umarnin da ke ƙasa domin canza canjin zuwa kwanan wata;
- Idan ka danna kan salula B3 cikakken aikin = MUTANE (A3, C2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.
Canza kwanan wata a cikin Excel
Hanyar da sauri da sauƙi don canja tsarin kwanan wata don kwayoyin da ke dauke da aikin EOMONTH shine zaɓi ɗaya daga jerin jerin zaɓuɓɓukan tsarawa a cikin Siffofin Siffofin Siffofin.
Matakan da ke ƙasa suna amfani da haɗin gajeren hanya na keyboard na Ctrl + 1 (lambar daya) don buɗe akwatin maganganun Siffofin Siffar.
Don canja zuwa tsarin kwanan wata:
- Ƙarƙirar sel a cikin takardun aiki wanda ya ƙunshi ko zai ƙunshi kwanakin;
- Danna maɓallin Ctrl + 1 don buɗe akwatin maganganun Siffofin Siffofin;
- Danna maɓallin Lamba a cikin akwatin maganganu;
- Danna kan Kwanan wata a cikin jerin jeri na Category (gefen hagu na maganganu);
- A cikin Maballin Nau'in (gefen dama), danna kan tsarin kwanan da ake so;
- Idan ɗakunan da aka zaɓa sun ƙunshi bayanai, akwatin Sample zai nuna samfoti na tsarin da aka zaɓa;
- Danna maɓallin OK don adana canjin yanayin kuma rufe akwatin maganganu.
Ga wadanda suka fi so su yi amfani da linzamin kwamfuta maimakon keyboard, hanyar da za a buɗe don buɗe akwatin maganganu shine:
- Danna danna maɓallin da aka zaɓa don buɗe menu mahallin;
- Zabi Siffofin Siffofin ... daga menu don buɗe akwatin maganganun Siffofin Siffar.
###########
Idan, bayan canzawa zuwa tsarin kwanan wata don tantanin halitta, tantanin halitta yana nuna jeri na alamun hash, saboda tantanin halitta ba shi da isasshen isa don nuna bayanan da aka tsara. Hada tantanin halitta zai gyara matsalar.