Ayyukan Ayyuka na Excel: Sakamakon Farawa / Ƙare Ranar

01 na 01

Ayyukan GABATARWA

Nemo Shirin Farawa ko Ƙare Ranar a Excel

Excel yana da yawa da aka gina a cikin kwanan wata da za a iya amfani dashi don lissafin ranar 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.

Excel WORKDAY aikin

A cikin yanayin aikin WORKDAY, yana samo farkon ko ƙarshen kwanan wata aiki ko aiki da aka ba kwanakin kwanakin aiki.

Yawan kwanakin kwanakin aiki na atomatik yana watsar da karshen mako da kowane kwanakin da aka sani a matsayin hutu.

Amfani da aikin WORKDAY ya haɗa da ƙididdigewa:

• ƙ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

HALKAR GASKIYAR GASKIYA DA GUDATARWA

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

Haɗin aikin aikin WORKDAY shine:

= GABATARWA (Farawa, Kwanaki, Ranaku Masu Tsarki)

Fara_date - (buƙata) ranar farawa na lokacin da aka zaba. Za a iya shigar da ainihin kwanan wata don wannan jayayya ko kuma tantance tantanin halitta zuwa wuri na wannan bayanan a cikin aikin aiki zai iya shiga a maimakon.

Days - (da ake bukata) tsawon aikin. Wannan wani lamba ne wanda yake nuna yawan kwanakin aikin da aka yi akan aikin. Don wannan hujja, shigar da yawan kwanakin aikin ko tantancewar salula akan wurin da wannan bayanan ke cikin aikin aiki.

Lura: Don neman kwanan wata da ya faru bayan bayanan START_date amfani da lamba mai mahimmanci na kwanaki . Don nemo kwanan wata da yake faruwa a gaban shawara na Start_date yana amfani da lamba mai mahimmanci don kwanaki . A wannan yanayin na biyu za'a iya gano ma'anar Start_date a matsayin ƙarshen aikin.

Ranaku Masu Tsarki - (na zaɓi) daya ko fiye ƙarin kwanakin da ba a kidaya a matsayin ɓangare na yawan adadin kwanakin aiki. Yi amfani da tantanin halitta game da wurin da aka sanya bayanai a cikin takardun aiki don wannan hujja.

Misali: Nemi Ƙare Ranar Kayan aikin

Kamar yadda aka gani a cikin hoton da ke sama, wannan misali zai yi amfani da aikin WORKDAY 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.

Lura: Don kauce wa matsalolin lissafi da zasu iya faruwa idan kwanakin ana shiga cikin bazata kamar yadda aka rubuta DATE aiki don shigar da kwanakin da aka yi amfani da shi a cikin aikin. Dubi ɓangaren Ƙaƙwalwar Kuskuren a karshen wannan koyawa don ƙarin bayani.

Shigar da Bayanan

D1: Fara Farawa: D2: Yawan kwanakin: D3: Holiday 1: D4: Holiday 2: D5: Ƙarshe Ranar: E1: = DATE (2012,7,9) E2: 82 E3: = DATE (2012,9,3 ) E4: = DATE (2012,10,8)

1. Shigar da wadannan bayanan zuwa cikin cell da ya dace:

Lura: Idan kwanakin cikin kwayoyin E1, E3, da E4 ba su bayyana kamar yadda aka nuna a cikin hoton da ke sama, duba don ganin cewa an tsara wadannan kwayoyin don nuna bayanai ta amfani da tsarin kwanan gajeren.

Shigar da aiki na WORKDAY

1. Danna kan tantanin halitta E5 don sa shi tantanin halitta - wannan shine inda za a nuna sakamakon aikin WORKDAY
2. Danna kan shafukan Formulas
3. Zaɓi Kwanan wata da Ayyukan lokaci> GABATARWA daga ribbon don kawo akwatin maganganun aikin
4. Danna maɓallin Start_date a cikin akwatin maganganu
5. Danna kan tantanin halitta E1 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu
6. Danna jerin kwanan wata a cikin akwatin maganganu
7. Danna kan tantanin halitta E2 a cikin takardun aiki don shigar da wannan tantanin halitta a cikin akwatin maganganu
8. Danna kan Ranar Ranaku a cikin akwatin maganganu
9. Jawo zaɓin Kayan E3 da E4 a cikin takardun aiki don shigar da waɗannan sanannun tantance cikin cikin maganganun maganganu
10. Danna Ya yi a cikin akwatin maganganu don kammala aikin
11. Ranar 11/2/2012 - ƙarshen ranar aikin - ya kamata ya bayyana a cikin cell E5 na takardar aiki
12. Ta yaya Excel ta ƙayyade kwanan wata shine:
    • Ranar da ta kasance kwanaki 82 bayan Yuli 9, 2012 ne ranar 31 ga Oktoba (ba a kidaya ranar farawa ɗaya daga cikin kwanaki 82 da aikin WORKDAY)
    • Ƙara zuwa kwanan nan kwanakin hutu biyu da aka ƙayyade (Satumba 3 da Oktoba 8) wanda ba'a kidaya a matsayin wani ɓangare na gardama na kwanaki 82
    • Saboda haka, ƙarshen ranar aikin ne Jumma'a Nuwamba 2, 2012
13. Lokacin da ka danna kan salula E5 cikakken aikin = BAYANE (E1, E2, E3: E4) ya bayyana a cikin maɓallin tsari a sama da takardun aiki

TALKAR KASHI KASHE KASHI

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 hujja na kwanaki a matsayin lamba ba - irin su kwanaki 82,755 - lambar za a ƙaddara - maimakon tasowa ko sama - zuwa kashi mai yawa na lamba: 82 days.