Ƙara ko rage kwanakin a cikin Excel Aiki ne na gama gari. Don haka, idan kuna yawan amfani da wannan kayan aikin ofis, wannan yana ɗaya daga cikin abubuwan da yakamata ku sani akai. Kuma za mu yi bayanin yadda ake aiwatar da shi.
Mun kawo muku koyawa mataki-mataki da wanda za ku koyi ƙarawa da rage kwanakin ba tare da wani ƙoƙari ba. Za ku ga cewa ya fi sauƙi fiye da yadda kuke tunani. Abinda kawai za ku yi shine sanin jerin ayyuka waɗanda zasu ba ku damar ƙarawa da cire kwalaye ta atomatik. Yanzu mun fara aiki.
Menene manufar ƙara ko rage kwanakin a cikin Excel?
Ta wannan aikin za mu iya ƙididdige tazarar lokaci, tsara abubuwan da suka faru, da waƙa da lokacin ƙarshe. A ƙasa muna dalla-dalla wasu fa'idodin wannan aiki.
Lissafin sharuɗɗan ko ƙarewa
Idan kuna aiki akan aikin da akwai lokutan ƙarewa, wannan zaɓin zai sa aikinku ya fi sauƙi kuma ku guje wa kuskuren kuskure.
Abin da muke yi a wannan yanayin shine farawa daga farkon kwanan wata da ƙara wasu adadin kwanakin zuwa gare shi, wanda zai kasance wadanda aka tsawaita wa’adin.
Tsakanin lokacin bin diddigi
Lokacin daga wata kwanan wata muna rage wani, za mu iya ƙididdige tazarar lokacin da ke tsakanin abubuwan biyu. Wannan zai zama da amfani musamman lokacin auna abubuwa kamar lokutan amsawa, ko duk wasu alamomi masu alaƙa da yanayin lokaci.
Ƙirƙirar kalanda da jadawali
Idan kuna buƙatar tsara lokacin aikin ku daki-daki, zaku iya amfani da zaɓin Ƙara ko rage kwanakin Excel don samar da kalanda, jadawali, ko tsara abubuwan da ke faruwa.
Misali, zaku iya kafa kalanda don gudanar da ci gaban matakan aikinku, ko ƙirƙirar jadawalin ziyarar ƙungiyar tallace-tallacen kasuwancin ku.
Sarrafa yarda da ƙayyadaddun lokaci
Idan ka cire daga kwanan wata ranar da aka yi niyya wanda dole ne ka kammala wani aiki da ita, zai kasance da sauƙi a gare ka don yin lokacin sa ido kuma ka tabbata ka gama duk abin da kake da shi a kan lokaci.
Lissafin shekaru
Rage kwanan wata daga ranar haihuwar mutum, za mu iya sauri lissafin shekarun ku. Za mu iya yin wannan tare da Excel kuma yana da amfani musamman a cikin Gudanar da Harkokin Ma'aikata, inda bayanan da aka rubuta game da ma'aikata kullum shine ranar haihuwar su, ba takamaiman shekarun su ba.
Rage kwanakin a cikin Excel
Anan muna da ayyuka daban-daban, kuma dole ne mu yi amfani da ɗaya ko ɗayan dangane da sakamakon da muke nema:
Rage kwanaki
Idan muna son sanin adadin lokaci nawa ya wuce tsakanin kwanan wata da wata, muna amfani da dabara kawai "= A2-B2". Zaɓin sel ɗin da kuke son aiki da su.
Rage kwanaki tare da farawa da ranar ƙarshe
Domin samun damar ɗaukar tunani don farkon lokacin da wani na ƙarshe, za mu yi amfani da dabarar "= KWANAKI (B2; A2)".
Rage watanni
Za mu iya amfani da aikin DATE.E don yin lissafin da sauri. A wannan yanayin dole ne mu samar da kwanan wata da lambar mara kyau wanda zai zama adadin watannin da za a rage. Misalin dabara zai zama wannan "= DATE.E ("15/6/2018" ;-3)". Wannan ya kamata ya ba mu sakamakon 15/3/2018.
Rage shekaru
Za mu iya amfani da nau'i biyu daban-daban. "= RANAR (SHEKARA (A2)-B2; WATA (A2); RANA (A2))" ko "=SHEKARA(A2)-SHEKARA(B2)".
Rage tare da DATEIF syntax
Wannan aikin yana ba mu damar sanin bambanci a cikin kwanaki tsakanin kwanakin biyu. Yana da mahimmanci cewa kwanan watan farawa yana da ƙima ƙasa da ranar ƙarshe, ko sakamakon zai ba mu kuskure.
Tsarin tsari shine "= DATEIF(ranar farawa: ƙarshen_date; raka'a). Idan naúrar ta kasance "D" Za mu san adadin kwanakin da suka shude a wannan lokacin, amma kuma muna iya amfani da wasu raka'o'in:
- Y. Yawan cika shekaru a cikin lokacin.
- M. Yawan cikakkun watanni a cikin wannan lokacin.
- M.D. Bambanci tsakanin kwanakin farkon ranar da ranar ƙarshe. A wannan yanayin, ana watsi da watanni da shekaru. Yin amfani da wannan hujja ba a ba da shawarar sosai ba saboda yana iya haifar da kurakurai daban-daban.
- YM Ya gaya mana bambanci tsakanin watannin farkon kwanan watan da ranar ƙarshe. Yi la'akari da kwanaki da shekaru.
- YD Sakamakon shine bambanci tsakanin kwanakin farko da na ƙarshe, yin watsi da shekaru.
Ƙara kwanakin a cikin Excel
Idan ya zo ga ƙara ko ragi kwanan wata a cikin Excel, dabarun ƙara ba su da bambanci da waɗanda muka gani zuwa yanzu.
Ƙara kwanaki
Muna amfani da dabara iri ɗaya kamar na raguwa, amma a wannan yanayin muna ƙara alama mai kyau maimakon mara kyau. Za mu sami wani abu kamar wannan "=B4+C4".
Ƙara kwanaki, shekaru da watanni
Anan abin da za mu yi shi ne ƙara tazarar lokacin da muke so a yi la'akari da mu:
- Don ƙara shekaru. "= RANAR (SHEKARA(A2)+B3;wata(A2),DAY(A2)).
- Don ƙara watanni. "= RANAR (SHEKARA (A2), WATAN(A2))+B3; RANA(A2)).
- Don ƙara kwanaki. "= RANAR (SHEKARA (A2); WATA (A2)); RANA(A2)+B6).
Muhimmiyar la'akari yayin ƙara ko rage kwanakin a cikin Excel
Don ƙarin fahimtar yadda wannan tsarin ke aiki, ku tuna cewa Excel yana adana kwanakin azaman jerin lambobi don samun damar yin aiki da su da yin lissafi. Wannan shirin ya cancanci, ta hanyar tsoho, ranar 1 ga Janairu, 1900 tare da lambar serial 1. Sauran kwanakin za su cancanci bisa ga wannan.
Don haka, a ranar 1 ga Janairu, 2008, ta karɓi lamba 39.448 a matsayin jerin lambar da za ta yi aiki, wato adadin kwanakin da suka shuɗe tun ranar 1 ga Janairu, 1900.
Wannan shine jujjuya kwanakin zuwa serial lambobi, wanda shirin yayi ta atomatik, wanda ke ba mu damar yin lissafin tare da kwanan wata. Wani abu da zai yi wuya a cimma ta kowace hanya dabam.
Ƙara ko rage kwanakin a cikin Excel zai zama da amfani ga ayyuka da yawa. Daga ƙididdige ƙayyadaddun ƙayyadaddun lokaci zuwa gudanar da ayyuka da bin diddigin tazarar lokaci. Wannan aiki ne wanda ke ceton ku mai yawa ƙoƙari da lokaci, kuma hakan zai taimaka muku duka a cikin rayuwar ilimi da sana'a. Muna fatan cewa bayan karanta koyawarmu za ku yi karin haske game da yadda ya kamata ku yi irin wannan aikin.