Shafukan Wizard na Google yana da ayyuka da yawa da aka gina a lokacin da za a iya amfani dasu don lissafin aiki.
Kowace kwanan wata yana aiki ne daban domin sakamakon ya bambanta daga wannan aiki zuwa gaba. Wanda kake amfani dashi, ya dogara da sakamakon da kake so.
01 na 03
Ayyukan WORKDAY.INTL
Shafukan Lissafi na Google WORKDAY.INTL Magana
A cikin yanayin aikin WORKDAY.INTL, yana samo ranar farawa ko ƙarewar kwanan wata aiki ko aiki da aka ba kwanakin kwanakin aiki.
Kwanan wata da aka ƙayyade kwanakin karshen mako an cire ta atomatik daga jimlar. Bugu da ƙari, kwanakin musamman, kamar sauran lokuta na ƙa'idodin, za a iya kawar da su.
Ta yaya aikin WORKDAY.INTL ya bambanta daga aikin WORKDAY shine WORKDAY.INTL ba ka damar tantance kwanakin da yawancin mutane suna kallon kwanakin karshen mako maimakon cirewa kwana biyu a kowane mako - Asabar da Lahadi - daga yawan kwanakin.
Amfani da aikin WORKDAY.INTL ya hada da kirgawa:
- ƙarshen kwanan wata don aikin tare da jerin kwanakin kwanakin aiki bayan an fara kwanan wata
- ranar farawa don aikin tare da kwanakin ƙididdigar kwanakin aiki kafin kwanakin ƙarshe
- kwanan wata don takarda
- kwanan wata da aka sa ran don kaya ko kayayyakin
HALITTAWA DA GUDATARWA DA GABATARWA
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin aikin WORKDAY shine:
= WORKDAY.INTL (start_date, num_days, karshen mako, holidays)
start_date - (da ake buƙata) ranar farawa na lokacin da aka zaba
- za a iya shigar da kwanan wata na farko don wannan hujja ko kuma tantancewar salula zuwa wuri na wannan bayanan a cikin takardar aiki za a iya shiga a maimakon
num_days - (da ake bukata) tsawon aikin
- saboda wannan hujja, shigar da lambar da ta nuna yawan kwanakin aikin da aka yi akan aikin
- shigar da adadin kwanakin aiki - irin su 82 - ko tantancewar salula akan wurin da wannan bayanan ya kasance a cikin takardun aiki
- don samo kwanan wata da ya faru bayan bayanan farawa, amfani da lamba mai mahimmanci don num_days
- don samo kwanan wata da yake faruwa a gaban hujjar farko, amfani da lamba mai mahimmanci don num_days
karshen mako - (na zaɓi) yana nuna wane kwanakin mako ana daukar su kwanaki ne na karshen mako kuma ya ware kwanakin nan daga yawan adadin kwanakin aiki
- saboda wannan hujja, shigar da lambar lambar karshen mako ko ƙididdigar salula ga wurin da wannan bayanan ke cikin aikin aiki
- idan an cire wannan gardama, ana amfani da tsoho 1 (Asabar da Lahadi) don lambar karshen mako
- duba cikakken jerin lambar lambobi a shafi na 3 na wannan tutorial
holidays - (na zaɓi) daya ko fiye da ƙarin kwanakin da aka cire daga yawan yawan kwanaki aiki
- kwanakin kwanakin za a iya shigar da su azaman lambobin kwanan wata ko tantanin halitta sunyi bayanin wuri na kwanan wata a cikin takardun aiki
- idan ana amfani da nassin tantanin halitta, dole ne a shigar da dabi'un kwanan wata a cikin sel ta amfani da ayyukan DATE , DATEVALUE ko TO_DATE don kaucewa kurakurai.
Misali: Nemi Ƙare Ranar Kashi tare da Ayyukan WORKDAY.INTL
Kamar yadda aka gani a hoton da ke sama, wannan misali zai yi amfani da aikin WORKDAY.INTL don gano ƙarshen kwanan wata don aikin da zai fara ranar 9 ga Yuli, 2012 kuma ya ƙare kwanaki 82 bayan haka.
Kwanaki biyu (Satumba 3 da Oktoba 8) da ke faruwa a wannan lokacin ba za a kidaya su a matsayin kwanaki 82 ba.
Don kauce wa matsalolin lissafin da zasu iya faruwa idan kwanakin sun shiga asirce da rubutu, aikin DATE za a yi amfani dashi don shigar da kwanakin da aka yi amfani da shi a matsayin gardama. Dubi ɓangaren Ƙaƙwalwar Kuskuren a karshen wannan koyawa don ƙarin bayani.
Shigar da Bayanan
A1: Fara Farawa: A2: Yawan kwanakin: A3: Holiday 1: A4: Holiday 2: A5: Ƙarshe Ranar: B1: = DATE (2012,7,9) B2: 82 B3: = DATE (2012,9,3 ) B4: = DATE (2012,10,8)- Shigar da wadannan bayanan zuwa cikin cell da ya dace:
Idan kwanakin da ke cikin sel b1, B3, da B4 ba su bayyana kamar yadda aka nuna a cikin hoton da ke sama, duba don ganin cewa an tsara waɗannan kwayoyin don nuna bayanan ta amfani da gajeren kwanan wata.
02 na 03
Shigar da aikin WORKDAY.INTL
Shigar da aikin WORKDAY.INTL
Shafukan yanar gizon Google ba su amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda ake samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.
- Danna kan b6 B6 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon WORKDAY.INTL
- Rubuta alamar daidai (=) biye da sunan aikin ranar aiki, intl
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunaye da haɗin ayyukan da suka fara da wasika W
- Lokacin da sunan WORKDAY.INTL ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashin zagaye cikin sakon B6
Shigar da Magana Magana
Kamar yadda aka gani a cikin hoton da ke sama, an shigar da muhawarar aikin WORKDAY.INTL bayan bayanan zagaye na B6.
- Danna sel B1 a cikin takardun aiki don shigar da wannan tantanin halitta kamar ƙaddamarwar farko
- Bayan nazarin tantanin halitta, rubuta takaddama ( , ) don aiki a matsayin mai raba tsakanin gardama
- Danna sel B2 don shigar da wannan tantanin halitta kamar lamarin num_days
- Bayan tantanin salula, rubuta wani takaddama
- Danna kan tantanin halitta B3 don shigar da wannan tantanin halitta kamar batun gardama na karshen mako
- Buga waɗannan sassan B4 da B5 a cikin takardun aiki don shigar da waɗannan maƙallan sutura kamar yadda ake biki
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa " ) " bayan bayanan karshe kuma don kammala aikin
- Ranar 11/29/2012 - kwanakin ƙarshe don aikin - ya kamata ya bayyana a tantanin halitta B6 na takardun aiki
- Lokacin da ka danna kan salula b5 cikakken aikin
= WORKDAY.INTL (B1, B2, B3, B4: B5) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Math bayan aikin
Ta yaya Excel ta ƙayyade kwanan wata shine:
- Ranar da aka yi kwanaki 82 bayan Agusta 5, 2012, ranar 27 ga watan Nuwamba (ba a kidaya kwanakin farko kamar ɗaya daga cikin kwanaki 82 da aikin WORKDAY.INTL)
- Ƙara zuwa kwanan nan kwanakin kwana biyu da aka ƙayyade (Agusta 19 da Nuwamba 15) wanda ba a kidaya a matsayin wani ɓangare na gardama na kwanaki 82
- Ranar ƙarshe na aikin shine, sabili da haka, ranar Alhamis, Nuwamba 29, 2012
WORKDAY.INTL Kuskuren Aiwatarwa
Idan ba a shigar da bayanan da aka ba da waɗannan ma'anar wannan aiki ba, daidai wadannan lambobin kuskuren suna bayyana a cikin tantanin halitta inda aikin WORKDAY yana samuwa:
- #VALUE! : yana bayyana a cikin sallar amsawa Idan ɗaya daga cikin muhawarar WORKDAY ba wata rana mai aiki ba (idan an shigar da kwanan wata azaman rubutu misali)
- #NUM !: ya bayyana a cikin sallar amsawa idan wani sakamako na ƙarshe ba daidai ba daga ƙara Fara_date da jayayya
- Idan ba a shigar da hujjar ranar ba a matsayin mahadar - irin su kwana 83,25 - lambar za a ƙaddara zuwa adadin ɓangaren lamba: 83 days
03 na 03