Yadda ake lissafin kwanaki tsakanin ranaku biyu a cikin zanen google.
Idan kuna son ƙididdige adadin kwanakin tsakanin ranaku biyu, kuna iya amfani da ayyukan KWANAKI, DATEDIF da NETWORKDAYS a cikin Google Sheets don yin hakan. KWANAKI da DATEDIF suna ƙirga duk kwanaki, yayin da NETWORKDAYS ba su haɗa da Asabar da Lahadi ba.
Ƙirga dukkan kwanakin tsakanin kwanakin biyu
Don ƙididdige kwanakin tsakanin ranaku biyu, ba tare da la'akari da ko yau ranar mako ce ko hutu ba, kuna iya amfani da ayyukan DAYS ko DATEDIF.
Amfani da aikin DAYS
Ayyukan DAYS shine mafi sauƙin amfani, muddin ba ku damu da keɓe ranakun hutu ko ƙarshen mako ba. Koyaya, DAYS za su lura da ƙarin kwanakin da aka ajiye a cikin shekarar tsalle.
Don amfani da DAYS don ƙidaya tsakanin kwanaki biyu, buɗe tebur Bayanan Google Sheets kuma danna kan komai a ciki. Nau'in =DAYS("01/01/2019","01/01/2018")Sauya kwanakin da aka nuna da naku.
Yi amfani da kwanakin a baya, don haka sanya ranar ƙarshe ta farko, kuma ranar farawa ta biyu. Amfani da ranar farawa da farko zai dawo da DAYS zuwa mummunan ƙima.
Kamar yadda misalin da ke sama ya nuna, aikin DAYS yana ƙididdige jimlar adadin kwanaki tsakanin ƙayyadaddun ranaku biyu. Tsarin kwanan wata da aka yi amfani da shi a misalin da ke sama shine tsarin Burtaniya, dd/mm/shekara. Idan kana cikin Amurka, tabbatar da amfani da MM/DD/YYYY.
Kuna buƙatar amfani da tsarin kwanan wata don yankin ku. Idan kana so ka yi amfani da wani tsari na daban, danna Fayil> Saitunan Fayil kuma canza ƙimar Gida zuwa wani wuri.
Hakanan zaka iya amfani da aikin DAYS tare da bayanan tantanin halitta. Idan ka zaɓi kwanaki biyu a cikin sel daban, zaka iya rubutawa =DAYS(A1, A11), kuma maye gurbin bayanan tantanin halitta A1 da A11 tare da nassoshin tantanin ku.
A cikin misalin da ke sama, ana yin rikodin bambanci na kwanaki 29 daga ajiyar kwanakin a cikin sel E6 da F10.
Amfani da aikin DATEDIF
Madadin DAYS shine aikin DATEDIF, wanda ke ba ka damar ƙididdige adadin kwanaki, watanni, ko shekaru tsakanin ƙayyadaddun ranaku biyu.
Kamar DAYS, DATEDIF yana yin la'akari da kwanakin tsalle kuma zai ƙirga duk kwanaki, maimakon iyakance ku zuwa kwanakin aiki. Ba kamar DAYS ba, DATEDIF baya aiki da juyi, don haka yi amfani da ranar farawa da farko da ƙarshen kwanan wata na biyu.
Idan kana so ka saka kwanan wata a cikin tsarin DATEDIF naka, danna kan tantanin halitta mara komai kuma ka rubuta =DATEDIF("01/01/2018","01/01/2019","D"), kuma ku maye gurbin kwanakin da kwanakin ku.
Idan kana so ka yi amfani da kwanakin daga nassoshin tantanin halitta a cikin dabarar DATEDIF, rubuta =DATEDIF(A7,G7,"D"), da kuma maye gurbin bayanan tantanin halitta A7 da G7 tare da nassoshin tantanin ku.
Ƙidaya kwanakin aiki tsakanin kwanakin biyu
Ayyukan DAYS da DATEDIF suna ba ku damar nemo kwanakin tsakanin kwanakin biyu, amma suna ƙirga duk kwanaki. Idan kuna son ƙirga kwanakin aiki kawai, kuma kuna son cire ƙarin hutu, kuna iya amfani da aikin NETWORKDAYS.
RANAR NETWORKS tana ɗaukar Asabar da Lahadi a matsayin ranakun ƙarshen mako, tare da cire waɗannan kwanakin kamar yadda ake ƙididdige su. Kamar DATEDIF, NETWORKDAYS yana amfani da ranar farawa da farko, sannan ranar ƙarshe.
Don amfani da NETWORKDAYS, danna kan komai a ciki kuma a buga =NETWORKDAYS(DATE(2018,01,01),DATE(2019,01,01)). Yin amfani da aikin DATE mai gida yana ba ku damar canza lambobi na shekaru, watanni, da kwanakin zuwa lambar kwanan wata, a cikin wannan tsari.
Maye gurbin lambobin da aka nuna tare da naku shekara, wata, da lambobin kwanan wata.
Hakanan zaka iya amfani da bayanan tantanin halitta a cikin tsarin NETWORKDAYS, maimakon aikin DATE.
كتب =NETWORKDAYS(A6,B6) Blank cell, kuma maye gurbin bayanan tantanin halitta A6 da B6 tare da nassoshin tantanin ku.
A cikin misalin da ke sama, ana amfani da aikin NETWORKDAYS don ƙididdige kwanakin aiki tsakanin ranaku daban-daban.
Idan kuna son keɓance wasu kwanaki daga lissafin ku, kamar wasu ranaku, kuna iya ƙara su a ƙarshen tsarin NETWORKDAYS ɗin ku.
Don yin wannan, danna kan blank cell kuma buga =NETWORKDAYS(A6,B6,{B6:D6}. A cikin wannan misali, A6 ita ce ranar farawa, B6 ita ce ranar ƙarshe, kuma kewayon B6: D6 kewayon sel ne masu ɗauke da ranakun hutu da za a keɓe.
Kuna iya maye gurbin bayanan tantanin halitta tare da kwanakin ku, ta amfani da aikin DATE, idan kun fi so. Don yin wannan, rubuta =NETWORKDAYS(E11,F13,{DATE(2019,11,18),DATE(2019,11,19)}), kuma maye gurbin bayanan tantanin halitta da ma'auni na kwanan wata tare da lambobin ku.
A cikin misalin da ke sama, ana amfani da kewayon kwanan wata don tsarin NETWORKDAYS guda uku. Tare da daidaitattun kwanakin aiki na 11 da aka ruwaito a cikin tantanin halitta B2, ana cire tsakanin ƙarin kwanakin hutu biyu zuwa uku a cikin sel B3 da B4.
