Sanin tsawon lokacin da ya wuce tsakanin takamaiman shekaru biyu yana da sauƙi kamar rage adadin su, duk da haka, a cikin wuraren aiki buƙatun yawanci sun fi rikitarwa. Don haka, Ba sabon abu ba ne ka sami kanka kana buƙatar cire gabaɗayan kwanakin a cikin takaddar Excel.. Wannan shirin wani suite ne da aka yi niyya don aiwatar da kowane nau'in ayyukan lissafin lissafi kuma raguwar kwanakin biyu ba banda. Ta wannan ma'anar, za mu nuna muku duk abin da kuke buƙatar sani don yin shi kuma ku yi amfani da shi a cikin maƙunsar bayanan ku.
Idan kana bukatar sanin kwanaki nawa, watanni ko shekaru nawa suka yi tsakanin kwanakin biyu, kun zo wurin da ya dace saboda za mu ba ku dukkan bayanan da za ku iya cimma a cikin dakika kadan..
Yadda ake cire ranaku a cikin Excel?
Rage kwanakin aiki ne wanda a cikin Excel yana ba da hanyoyi da yawa don cimma sakamako, duk da haka, wanda za mu ɗauka zai dogara ne akan yadda muke son nuna shi.. A wannan ma'anar, shirin yana iya nuna kwanakin da suka shude, watanni da kuma shekaru, ko da yake daban. Idan kana son ganin cikakken bayanin, to dole ne ka shagaltar da sel guda 3 don samar da kowane sakamako sannan daga baya, ka shagaltu da dabarar da za a hada jerin haruffa. Duk da haka, Excel shiri ne wanda dama a buɗe kuma akwai hanyoyin da za a gina ƙididdiga waɗanda ke ba mu damar nuna sakamakon raguwar kwanakin a cikin tsarin da muke so.
A nan za mu ga mafi sauki kuma mafi m hanyoyin don cimma shi.
Rage asali na kwanan wata
Wannan ita ce hanya mafi sauƙi don cire ranaku a cikin Excel kuma kawai game da yin ragi ne, zaɓi sel inda kwanakin da ake tambaya suke.. Ta wannan hanyar, duk abin da za ku yi shine kamar haka:
- Danna sau biyu akan tantanin halitta inda kake son sakamakon.
- Shigar da alamar daidai ( = ).
- Zaɓi kwanan wata lambar 1.
- Saka alamar ragi (-).
- Zaɓi kwanan wata lambar 2.
- Buga Shigar.
Wannan zai dawo da adadin kwanakin da suka wuce tsakanin kwanakin biyun.. Ya kamata a lura cewa lambar kwanan wata 1 dole ne ya zama na baya-bayan nan, don samun adadi mai kyau.
Rage kwanakin tare da aikin DATEDIF
Idan kana neman aikin IDAN KWANTA a cikin kundin Excel, mai yiwuwa ba za ku same shi ba, duk da haka, yana nan kuma yana aiki. Ayyukansa daidai ne don nuna bambanci tsakanin kwanakin biyu, tare da yiwuwar ma'anar idan muna so a bayyana shi a cikin kwanaki, shekaru ko watanni. Ta wannan hanyar, idan kuna son samun cikakken bayani game da lokacin da ya wuce, zai isa ya mamaye sel 3 a jere, ɗaya don kowane ma'auni na lokaci.
Ma'anar wannan tsari shine:
= DATEDIF (Kwanan wata 1, Kwanan wata2)
Koyaya, sabanin yanayin da ya gabata, a cikin aikin DATEDIF muna buƙatar lambar kwanan wata 1 don zama mafi tsufa. Idan muka yi shi akasin haka, shirin zai jefa kuskuren #¡NUM!
Don aiwatar da raguwar kwanakin da kuma nuna sakamakon a cikin kwanaki, watanni da shekaru dole ne ku yi masu zuwa:
- Danna sau biyu akan tantanin halitta.
- Shigar da aikin IDAN KWANTA da bude baki.
- Danna kan kwanan wata lamba 1 (mafi tsufa) kuma shigar da waƙafi.
- Danna kan kwanan wata lamba 2 (mafi kwanan baya) kuma shigar da waƙafi.
- Shigar da alamar ambato alamun haruffa d, y da m waɗanda ke wakiltar kwanaki, shekaru da watanni bi da bi.
- Rufe baka.
- Buga Shigar.
Dangane da nau'in wasiƙar da kuka saka a ƙarshen tsakanin ƙididdiga, za a nuna sakamakon a cikin kwanaki, watanni ko shekaru. Don haka, zaku iya cire ranaku cikin sauƙi a cikin Excel kuma ku san adadin lokacin da ya wuce tsakanin takamaiman maki biyu akan kalanda.
ƙarshe
Rage kwanan wata a cikin Excel hanya ce mai mahimmanci don sanin duk wanda ke aiki da bayanai kuma yana buƙatar yin lissafin lokaci.. Ko da yake yana iya zama kamar ɗan rikitarwa da farko, yana da sauƙin amfani da zarar kun fahimci abubuwan yau da kullun. Yi la'akari da cewa kowane ɗayan hanyoyin da muka bayyana yana da keɓantacce kuma fahimtar su zai dogara ne akan samun ingantaccen sakamako.
Yana da mahimmanci a tuna cewa Excel yana amfani da Janairu 1, 1900 a matsayin ranar tushe, don haka yana da mahimmanci a kiyaye wannan lokacin shigar da kwanan wata. Bugu da kari, wajibi ne a san yadda ake tsara sel ta yadda za a nuna sakamakon yadda muke so.
Kamar yadda muka gani, akwai hanyoyi daban-daban don cire kwanan wata a cikin Excel, daga yin amfani da aikin DATEDIF zuwa lissafin hannu ta amfani da hanyoyi masu sauƙi. Kowace hanya tana da abũbuwan amfãni da rashin amfani, don haka yana da daraja don zaɓar zaɓin da ya fi dacewa da bukatun ku. Ka tuna, kuma, cewa kuna da yuwuwar yin aiki yayin aikinku tare da kowace hanya don sanin kowane ɗayan kuma wannan ita ce babbar hanyar ku ta rage kwanakin a cikin Excel.