Masiku Owerengeka Pakati pa Mapepala mu Google Mapepala

Masewera: Mmene Mungagwiritsire ntchito Ntchito ya NETWORKDAYS

Maofesi a Google ali ndi ntchito zamasiku amodzi zomwe zimapezeka, ndipo ntchito iliyonse mu gulu imagwira ntchito yosiyana.

Ntchito ya NETWORKDAYS ingagwiritsidwe ntchito kuwerengera nambala ya ntchito zonse zamalonda kapena ntchito pakati pa masiku oyambirira ndi kumapeto. Ndi ntchitoyi, masiku otsiriza (Loweruka ndi Lamlungu) amachotsedwa kuchoka pa chiwerengerocho. Masiku enieni, monga maholide ovomerezeka, angathekenso.

Gwiritsani ntchito NETWORKDAYS pokonzekera kapena kulembera malingaliro kuti mudziwe nthawi ya polojekiti yomwe ikubwera kapena kubwereranso-chiwerengereni nthawi yomwe mwathera pomaliza.

01 a 03

NETWORKDAYS Ntchito ya Syntax ndi Arguments

Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .

Chidule cha ntchito ya NETWORKDAYS ndi:

= NETWORKDAYS (start_date, end_date, maholide)

Zokambirana ndi izi:

• kuyamba_date - (zofunikira) tsiku loyamba la nthawi yosankhidwa
• mapeto_date - (zofunikira) tsiku lomaliza la nthawi yosankhidwa

Gwiritsani ntchito mfundo zamtengo wapatali, nambala ya serial , kapena selo loyang'ana pa malo a deta iyi papepala la zifukwa zonse.

• maholide - (zosankha) tsiku limodzi kapena zina zina zowonjezera zomwe sizichotsedwa masiku onse ogwira ntchito

Masiku a tchuthi akhoza kukhala amtundu wamtundu womwe umalowa mwachindunji kapena mawonekedwe a selo kumalo a deta mu tsamba la ntchito.

Zotsatira : Popeza NETWORKDAYS sichimasintha deta kuti zikhale zatsopano, zolemba zamkati zimalowa mwachindunji kuntchito zokhudzana ndi zifukwa zitatu zomwe ziyenera kuikidwa pogwiritsa ntchito DATE kapena DATEVALUE ntchito kuti zisawononge zolakwika, monga momwe zasonyezedwera mzere 8 wa chithunzi chomwe chili ndi mutu uwu .

The #VALUE! Ndalama yamabvuto imabweretsedwa ngati mkangano uliwonse uli ndi tsiku losavomerezeka.

02 a 03

Maphunziro: Lerengani Nambala ya Ntchito Zapakati Pakati pa Nthawi Zili

Maphunzirowa akuwonetsera momwe mitundu yosiyanasiyana ya ntchito ya NETWORKDAYS imagwiritsira ntchito kuwerengera masiku a ntchito pakati pa July 11, 2016, ndi November 4, 2016, mu Google Mapepala.

Gwiritsani ntchito chithunzithunzi chomwe chikutsatira ndondomekoyi ndikutsatirana ndi phunziroli.

Mwachitsanzo, maholide awiri (September 5 ndi Oktoba 10) amapezeka panthawiyi ndipo amachotsedwa pa chiwerengerocho.

Chithunzichi chikusonyeza momwe zifukwa zogwirira ntchito zingalowerere mwachindunji ku ntchito monga tsiku lofunika kapena ngati nambala yachinsinsi kapena monga ma selo omwe amapezeka pa deta.

Njira zolowera Ntchito ya NETWORKDAYS

Maofesi a Google samagwiritsa ntchito bokosi la dialogs kuti alowe m'mawu a ntchito monga momwe angapezere mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.

1. Dinani pa selo C5 kuti mupange selo yogwira ntchito .
2. Lembani chizindikiro chofanana ( = ) chotsatira dzina la ntchito zotseguka .
3. Pamene mukuyimira, bokosi lopangira mothandizilo likuwoneka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata N.
4. Pamene mawebusaiti amatchulidwa mu bokosi, dinani pa dzina ndi ndondomeko ya mouse kuti mulowetse dzina la ntchito ndi mabala oyamba kapena ozungulira " ( " mu selo C5.
5. Dinani pa selo A3 mu tsamba lothandizira kuti mulowetse mndandanda wa seloyi monga mtsutso_kuyamba .
6. Pambuyo powerenga selo, lembani comma kuti mukhale olekanitsa pakati pa zotsutsana.
7. Dinani pa selo A4 kuti mulowetse mndandanda wa selo ngati mapeto a_date .
8. Pambuyo powerenga selo, yesani kachiwiri kachiwiri.
9. Onetsetsani maselo A5 ndi A6 pa tsamba kuti mulowetse mafotokozedwe angapo a maselo monga mgwirizano wa tchuthi .
10. Lembani fungulo lolowani mu Enter mu khididi kuti muwonjezere malemba omaliza " ) " ndi kumaliza ntchitoyi.

Chiwerengero cha masiku ogwira ntchito-83 chikuwonekera mu selo C5 ya worksheet.

Mukasindikiza pa selo C5, ntchito yonse
= NETWORKDAYS (A3, A4, A5: A6) ikuwoneka muzenera zamatabwa pamwamba pa tsamba.

03 a 03

Masewero Otsogolera Ntchitoyi

Momwe Mapepala a Google akufikira yankho la 83 mzere 5 ndi:

• Chiwerengero cha masabata pakati pa July 11 ndi November 4, 2016, ndi 85 (masabata 17 x 5 masiku pa sabata). Ichi ndi zotsatira pa mizere 3 ndi 4 pomwe mkangano wa tchuthi wachotsedwa.
• Kuchokera pa chiwerengerochi, masiku awiri a tchuthi omwe atchulidwa (September 5 ndi 10 Oktoba) amachotsedwa kuti achoke pamapeto a masiku 83 antchito.

Dziwani: Ngati masiku otsiriza ndi ena osati Loweruka ndi Lamlungu kapena tsiku limodzi pa sabata, gwiritsani ntchito ntchito ya NETWORKDAYS.INTL.