Ƙidaya kwanakin tsakanin kwanan wata a cikin Google Sheets

Koyarwa: Yadda ake amfani da NETWORKDAYS Function

Google Sheets yana da yawan ayyuka na kwanan wata, kuma kowane aiki a cikin rukuni yana aiki daban.

Ayyukan NETWORKDAYS za a iya amfani da su don tantance yawan yawan kasuwancin ko kwanakin aiki tsakanin lokacin da aka fara da kuma ƙarshen kwanakin. Tare da wannan aikin, kwanakin karshen mako (Asabar da Lahadi) an cire su ta atomatik daga jimlar. Ƙayyadadden kwanakin, kamar sauran lokuta na ƙa'idodi, za a iya kawar da su.

Yi amfani da NETWORKDAYS lokacin tsarawa ko rubuta bayanan don ƙayyade lokaci don wani aikin mai zuwa ko don dawowa-lissafin yawan lokacin da aka kashe a kan kammala.

01 na 03

NETWORKDAYS Shirye-shiryen aiki da jayayya

Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .

Haɗin aikin NETWORKDAYS shine:

= NETWORKDAYS (start_date, end_date, holidays)

Maganawar ita ce:

• fara_date - (buƙata) ranar farawa na lokacin zaba
• end_date - (da ake buƙata) ƙarshen zamani na zaɓaɓɓen lokacin

Yi amfani da lambobin kwanan wata, lambobin waya , ko tantancewar salula zuwa wurin da wannan bayanan ya kasance a cikin takardun aiki don duka muhawara.

• holidays - (na zaɓi) daya ko fiye da ƙarin kwanakin da aka cire daga yawan yawan kwanaki aiki

Lokaci na kwanan wata zai iya zama dabi'u na kwanan wata da aka shigar da kai tsaye cikin wannan tsari ko tantanin halitta yana nuni da wurin da aka tattara bayanai a cikin takardun aiki.

Bayanan kula: Tunda NETWORKDAYS ba ta juyo da bayanai zuwa tsarin kwanan wata ba, ana amfani da kwanan wata da aka shiga cikin aikin ga dukan muhawara guda uku ta yin amfani da DATE ko DATEVALUE ayyuka don kauce wa kurakuran lissafi, kamar yadda aka nuna a jere na 8 na hoton da ke bin wannan labarin .

A #VALUE! An dawo da darajar kuskure idan duk wata gardama ta ƙunshi ranar da ba daidai ba.

02 na 03

Koyawa: Ka ƙidaya yawan kwanakin ayyukan tsakanin kwanaki biyu

Wannan darasi ya nuna yadda yawancin bambancin aikin NETWORKDAYS ke amfani da su don lissafin yawan kwanakin aiki tsakanin Yuli 11, 2016, da Nuwamba 4, 2016, a cikin Google Sheets.

Yi amfani da hoton da ke bin wannan labarin don bi tare da wannan koyawa.

A cikin misali, kwana biyu (Satumba 5 da Oktoba 10) faruwa a wannan lokacin kuma an cire su daga jimlar.

Hoton yana nuna yadda za a iya shigar da muhawarar aikin ta kai tsaye a cikin aikin a matsayin matsayin kwanan wata ko kuma a matsayin lambobin waya ko kuma yadda tantanin halitta ke nuni da wurin da aka samu bayanai a cikin takardun aiki.

Matakai don Shigar da aikin NETWORKDAYS

Google Sheets ba ya amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda za'a samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.

1. Danna kan C5 C5 don sa shi tantanin halitta mai aiki .
2. Rubuta alamar daidai ( = ) biye da sunan ayyukan networkdays .
3. Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunaye da haɗin ayyukan da suka fara tare da wasika.
4. Lokacin da sunan networkdays ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da aikin aiki da bude budewa ko sashin layi " ( " zuwa cikin ƙwayar C5.
5. Danna kan A3 a cikin takardun aiki don shigar da wannan tantanin halitta kamar ƙaddamarwa ta farko .
6. Bayan nazarin tantanin halitta, rubuta takaddama don aiki a matsayin mai raba tsakanin gardama.
7. Danna kan salula A4 don shigar da wannan tantanin halitta kamar ƙaddamarwa ta ƙarshe .
8. Bayan tantanin tantanin halitta, rubuta nau'i na biyu.
9. Sanya siffofin A5 da A6 a cikin takardun aiki don shigar da wannan jigon tantanin halitta kamar yadda ake biki .
10. Latsa maɓallin shigarwa akan keyboard don ƙara maƙallin rufewa " ) " kuma don kammala aikin.

Yawan kwanakin aiki-83-ya bayyana a cikin ƙwayar C5 na takardar aiki.

Lokacin da ka danna kan tantanin C5, cikakken aikin
= NETWORKDAYS (A3, A4, A5: A6) yana bayyana a cikin maɓallin tsari a sama da takardun aiki.

03 na 03

Ayyukan Bayanan Bayan Bayanan

Yadda Google Sheets ya zo a amsar 83 a jere 5 shine:

• Jimlar yawan lokutan makonni tsakanin Yuli 11 da Nuwamba 4, 2016, daidai 85 (mako 17 x 5 a kowace mako). Sakamakon sakamakon layuka 3 da 4 inda an cire batu na biki .
• Daga wannan jimlar, kwanakin hutu biyu da aka ƙayyade (Satumba 5 da Oktoba 10) an cire su don barin sakamakon kwanakin 83.

Lura: Idan kwanakin karshen mako banda ranar Asabar da Lahadi ko wata rana a kowane mako, yi amfani da aikin NETWORKDAYS.INTL.