Ntchito Yowonjezera Ntchito: Pezani Dongosolo Loyambira / Kutsiriza

01 ya 01

Ntchito YA NTCHITO

Pezani Tsiku Loyambira Kapena Kutsiriza Mu Excel

Excel ili ndi ntchito zingapo zomwe zingagwiritsidwe ntchito powerengetsera tsiku la ntchito.

Tsiku lililonse ntchito imagwira ntchito yosiyana kuti zotsatira zikhale zosiyana ndi ntchito imodzi. Chomwe mumagwiritsa ntchito, chotero chimadalira zotsatira zomwe mukufuna.

Ntchito ya WORKDAY ya Excel

Pankhani ya NTCHITO YA NTCHITO, imapeza tsiku loyamba kapena lomalizira la polojekiti kapena ntchito yomwe inapatsidwa masiku angapo a ntchito.

Chiwerengero cha masiku ogwira ntchito sichimasintha pamapeto a sabata ndi masiku aliwonse amene amadziwika ngati maholide.

Kugwiritsira ntchito ntchito WORKDAY ikuphatikiza kuwerengera:

• Tsiku lomaliza la polojekiti yomwe ili ndi nambala yochuluka ya masiku ogwira ntchito patsiku loyamba loyamba
• tsiku loyamba la polojekiti yomwe ili ndi chiwerengero cha masiku ogwira ntchito tsiku lisanafike
• tsiku loyenera la invoice
• Tsiku loyenera kulandira katundu kapena zipangizo

Syntax ndi Maganizo a Ntchito ya WORKDAY

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

Chidule cha ntchito ya WORKDAY ndi:

= WORKDAY (Start_date, Days, Holidays)

Yambani_date - (yofunikira) tsiku loyamba la nthawi yosankhidwa. Tsiku loyambirira lenileni likhoza kulowetsedweratu pazokambiranazi kapena selo loyang'ana pa malo a deta iyi mu tsamba lothandizira likhoza kulowa mmalo mwake.

Masiku - (zofunikira) kutalika kwa polojekitiyi. Ichi ndi chiwerengero chachikulu chowonetsera chiwerengero cha masiku ogwira ntchito omwe adachitidwa pulojekitiyi. Potsutsa izi, lowetsani chiwerengero cha masiku ogwira ntchito kapena mawonekedwe a selo kumalo a deta iyi mu tsamba la ntchito.

Zindikirani: Kuti mupeze tsiku limene likuchitika pambuyo pa mtsutso wa Start_date ntchito yaikulu ya masiku . Kuti mupeze tsiku limene likuchitika mtsutso wa Start_date usagwiritsire ntchito nambala yochepa ya masiku . Muchiwiri ichi, mkangano wa Start_date ukhoza kudziwika ngati tsiku lomaliza la polojekiti.

Maholide - (mwasankha) masiku amodzi kapena ena oonjezera omwe sawerengedwa ngati gawo la masiku onse ogwira ntchito. Gwiritsani ntchito mafotokozedwe a selo kumalo a deta mu tsamba lothandizira kukangana.

Chitsanzo: Pezani Tsiku Lomaliza la Ntchito

Monga momwe tawonera pa chithunzi pamwambapa, chitsanzo ichi chigwiritsa ntchito ntchito ya WORKDAY kupeza tsiku lomaliza la polojekiti yomwe imayamba pa July 9, 2012 ndikumaliza masiku 82 pambuyo pake. Maholide awiri (September 3 ndi Oktoba 8) omwe amapezeka panthawiyi sadzakhala ngati gawo la masiku 82.

Zindikirani: Kuti mupewe mavuto owerengera omwe angachitike ngati masiku atalowa mwachinsinsi polemba DATE ntchito idzagwiritsidwa ntchito kulemba masiku omwe amagwiritsidwa ntchito. Onani gawo la zolakwika zamagulu pamapeto a phunziro ili kuti mudziwe zambiri.

Kulowa Deta

D1: Tsiku loyambira: D2: Chiwerengero cha masiku: D3: Kutchulidwa 1: D4: Tchuthi 2: D5: Tsiku lomaliza: E1: = DATE (2012,7,9) E2: 82 E3: = DATE (2012,9,3) ) E4: = DATE (2012,10,8)

1. Lowani deta zotsatirazi mu selo yoyenera:

Zindikirani: Ngati masiku ali m'maselo E1, E3, ndi E4 sakuwonekera monga momwe asonyezedwera pamwambapa, yang'anani kuti muwone kuti maselowa amawonekedwe kuti asonyeze deta pogwiritsa ntchito mawonekedwe a tsiku lalifupi.

Kulowa Ntchito YA WORKDAY

1. Dinani pa selo E5 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za NTCHITO YA NTCHITO idzawonetsedwa
2. Dinani pa Fomu ya Fomu
3. Sankhani Tsiku ndi Nthawi Ntchito> WORKDAY kuchokera ku kaboni kuti mubweretse bokosi la ntchito
4. Dinani pa Start_date mzere mu bokosi la bokosi
5. Dinani pa selo E1 mu tsamba lokuthandizani kuti mulowetse selo ili mu bokosi la bokosi
6. Dinani pa mzere wa masiku mubox
7. Dinani pa selo E2 mu tsamba lothandizira kuti mulowetse selo ili mu bokosi la bokosi
8. Dinani pa Mndandanda wa Tchuthi mubox
9. Kokani osankhira maselo E3 ndi E4 mu tsamba lokuthandizani kuti mulowetse mafotokozedwe a maselo mu bokosi la bokosi
10. Dinani OK kubox kukamaliza ntchitoyi
11. Tsiku la 11/2/2012 - tsiku lomaliza la polojekitiyi - liyenera kuwonetsedwa mu selo E5 la tsamba
12. Momwe Excel ikuwerengera tsikuli ndi:
    • Tsiku limene liripo masiku 82 kuchokera pa July 9, 2012 ndi October 31 (tsiku loyambirira silidali ngati limodzi la masiku 82 ndi ntchito ya WORKDAY)
    • Kuonjezera mpaka tsiku lino, masiku awiri a tchuthi atchulidwa (September 3 ndi Oktoba 8) omwe sanawerengedwe ngati gawo la kutsutsana kwa masiku 82
    • Choncho, tsiku lomaliza la polojekitiyi ndi Lachisanu November 2, 2012
13. Mukasindikiza pa selo E5 ntchito yonse = WORKDAY (E1, E2, E3: E4) ikuwoneka pa bar barula pamwamba pa tsamba

NTCHITO YA NTCHITO YA NTCHITO Zolakwika Makhalidwe

Ngati deta ya zifukwa zosiyanasiyana za ntchitoyi sizinalembedwe molondola malingaliro olakwika otsatirawa akuwonekera mu selo kumene ntchito ya WORKDAY ilipo:

• #VALUE! : imawoneka mu selo yankho Ngati imodzi mwa mfundo za WORKDAY sizolondola (ngati tsikulo linalembedwera monga chitsanzo)
• #NUM !: ikuwoneka mu selo yankho ngati tsiku losavomerezeka limachokera kuwonjezera zowonjezera Start_date ndi Days
• Ngati masiku akutsutsana sakulowa ngati nambala - monga masiku 82.75 - nambala idzaponyedwa - osati kuzungulira kapena pansi-ku chiwerengero chachikulu cha nambala: masiku 82.