Don aiwatar da wasu ayyuka a cikin Excel, kuna buƙatar ƙayyade yawan kwanakin da suka wuce tsakanin wasu ranaku. Abin farin ciki, shirin yana da kayan aikin da za su iya magance wannan batun. Bari mu bincika cikin waɗanne hanyoyi zaka iya lissafa bambancin kwanan wata a Excel.
Lissafin kwana
Kafin ka fara aiki tare da kwanakin, kana buƙatar tsara sel don wannan tsari. A mafi yawan lokuta, idan ka shigar da saitin halayen da yayi kama da kwanan wata, tantanin da kansa za'a sake shi. Amma yana da kyau a yi shi da hannu don kare kanka daga abubuwan mamaki.
- Zaɓi sararin takarda wanda kake shirin aiwatar da lissafin. Danna-dama akan zabi. Ana kunna menu na mahallin. A ciki, zaɓi abu "Tsarin kwayar halitta ...". A madadin haka, zaku iya buga gajerar hanyar rubutu akan maballin Ctrl + 1.
- Tsarin tsarawa yana buɗe. Idan budewar bai faru ba a cikin shafin "Lambar"to ya kamata ka shiga ciki. A cikin toshe na sigogi "Lambobin adadi" sanya canjin a wuri Kwanan Wata. A cikin ɓangaren dama na taga, zaɓi nau'in bayanai waɗanda za mu yi aiki da su. Bayan haka, don gyara canje-canje, danna maɓallin "Ok".
Yanzu duk bayanan da zasu ƙunshi ƙwayoyin da aka zaɓa, shirin zai gane shi azaman kwanan wata.
Hanyar 1: lissafi mai sauƙi
Hanya mafi sauki ita ce yin ƙididdigar bambancin ranaku tsakanin kwanakin ta amfani da tsari na yau da kullun.
- Mun rubuta a cikin sel daban daban na tsara kwanan wata, bambanci tsakanin wanda ke buƙatar yin lissafta.
- Zaɓi tantanin da za'a nuna sakamakon shi. Ya kamata a saita shi zuwa tsarin gama gari. Matsayi na ƙarshe yana da mahimmanci, tunda idan tsarin kwanan wata yake a cikin wannan tantanin halitta, to a wannan yanayin sakamakon zai yi kama "dd.mm.yy" ko wani, mai dacewa ga wannan tsarin, wanda ba daidai ba ne sakamakon lissafin. Tsarin sel ko kewayon yanzu ana iya duba shi ta hanyar nuna shi a cikin shafin "Gida". A cikin akwatin kayan aiki "Lambar" akwai filin da aka nuna wannan alamar.
Idan yana da darajar wanin "Janar", sannan a wannan yanayin, kamar lokacin da ya gabata, ta amfani da menu na mahallin zamu fara taga tsarawa. A cikin sa a cikin shafin "Lambar" saita nau'in tsara "Janar". Latsa maballin "Ok".
- A cikin tantanin halitta wanda aka tsara don tsarin gabaɗaya, sanya alamar "=". Danna kan wayar wanda daga baya na kwanakin biyu (ƙarshen) ya kasance. Bayan haka, danna alamar keyboard "-". Bayan haka, zaɓi tantanin da ya ƙunshi farkon kwanan wata (fara).
- Don ganin lokacin da ya wuce tsakanin waɗannan kwanakin, danna maɓallin Shigar. Sakamakon za a nuna shi a cikin sel wanda aka tsara don tsarin gama gari.
Hanyar 2: RANDATE aiki
Hakanan zaka iya amfani da aiki na musamman don ƙididdige bambancin kwanakin. HADA. Matsalar ita ce ba ta cikin jerin Wiirƙwaran Aiki, saboda haka dole ne ku shigar da dabara da hannu. Syntax kamar haka:
= DATE (fara_date; karshen_date; raka'a)
"Unit" - Wannan itace hanyar da za'a nuna sakamakon a cikin tantanin da aka zaɓa. Halin da raka'a za'a dawo da sakamakon ya dogara da irin halayen da za'a musanya a wannan sigar:
- "y" - cikakken shekaru;
- "m" - cikakken watanni;
- "d" - kwanaki;
- "YM" - bambanci a cikin watanni;
- "MD" - bambanci a cikin kwanaki (watanni da shekaru ba a la'akari da su);
- “YD” - bambanci a cikin ranakun (ba a la'akari da shekaru).
Tun da yake muna buƙatar ƙididdige bambancin yawan kwanakin tsakanin ranakun, mafi kyawun bayani zai zama don amfani da zaɓi na ƙarshen.
Hakanan kuna buƙatar kulawa da cewa, sabanin hanyar amfani da tsari mai sauƙi wanda aka bayyana a sama, lokacin amfani da wannan aikin, ranar farko ya kamata ya kasance a farkon, kuma ƙarshen ƙarshen ya kamata ya kasance a karo na biyu. In ba haka ba, lissafin ba zai zama ba daidai ba.
- Muna rubuta folila a cikin tantanin da aka zaɓa, gwargwadon yanayin aikinsa wanda aka bayyana a sama, da kuma mahimman bayanai ta hanyar farawa da ƙarshen zamani.
- Don yin lissafi, danna maɓallin Shigar. Bayan wannan, sakamakon, a cikin wata lamba da ke nuna adadin kwanakin tsakanin ranakun, za a nuna su a cikin takaddarar tantanin halitta.
Hanyar 3: Lissafta kwanakin aiki
A cikin Excel, Hakanan yana yiwuwa a lissafa kwanakin aiki tsakanin ranakun biyu, wato ban da karshen mako da hutu. Don yin wannan, yi amfani da aikin KYAUTA. Ba kamar bayanin da ya gabata ba, yana nan cikin jerin masu ba da Shafin aiki. Ginin kalma na wannan aikin kamar haka:
= NET (fara_date; karshen_date; [biki])
A cikin wannan aikin, manyan muhawara iri ɗaya ce ta mai aiki HADA - farawa da kwanan wata. Bugu da kari, akwai mahawara na zabi. "Hutu".
Madadin haka, ya kamata a sauya kwanakin ranakun hutu na jama'a, idan akwai, na tsawon lokacin da aka rufe. Aikin yana kirga duk ranakun da aka kayyade, ban da Asabar, Lahadi, da kuma waɗancan ranakun da mai amfani ya ƙara a cikin hujja "Hutu".
- Zaɓi wayar wanda sakamakon lissafin zai kasance. Latsa maballin "Saka aikin".
- Zazzage Aiki ya buɗe. A cikin rukuni "Cikakken jerin haruffa" ko "Kwanan wata da lokaci" neman kashi "CHISTRABDNI". Zaɓi shi kuma danna maballin. "Ok".
- Farashin muhawara na aiki zai bude. Shigar da ranar farkon da ƙarshen lokacin, kazalika da ranakun hutu, idan akwai, a cikin hanyoyin da suka dace. Latsa maballin "Ok".
Bayan abubuwan da aka ambata a sama, yawan kwanakin kwanakin aiki na ƙayyadadden lokaci za'a nuna su a cikin tantanin da aka zaɓa a baya.
Darasi: Wizard ɗin Aiki a cikin Excel
Kamar yadda kake gani, Excel yana bawa mai amfani dashi kayan aiki mai dacewa don ƙididdige yawan kwanakin tsakanin ranakun biyu. Haka kuma, idan kawai kuna buƙatar lissafta bambancin ne a cikin kwanaki, to mafi kyawun zaɓi zai zama don amfani da tsari mai sauƙi ɗaya, maimakon amfani da aiki HADA. Amma idan kuna buƙatar, alal misali, don ƙididdige yawan kwanakin aiki, to aikin zai zo don ceton KYAUTA. Wato, kamar yadda koyaushe, mai amfani ya kamata ya yanke shawara a kan kayan aikin kisa bayan ya saita takamaiman aiki.
