Umsebenzi we-YEARFRAC, njengoko igama layo libonisa, ungasetyenziselwa ukufumana ukuba yiyiphi inxalenye yonyaka imelwe ngethuba lexesha phakathi kwemihla emibini.
Ezinye imisebenzi ze-Excel zokufumana inani leentsuku phakathi kwemihla emibini zikhawulelwe ukubuyisela ixabiso kuyo yonke iminyaka, iinyanga, iintsuku, okanye ukudibanisa kwezi zintathu.
Ukusetyenziswa kwizibalo ezalandelayo., Eli xabiso kufuneka liguqulwe libe yifom. I-YEARFRAC, ngakolunye uhlangothi, ubuyisela umahluko phakathi kwemihla emibini kwifom ye-decimal ngokuzenzekelayo - njengeminyaka eyi-1.65-yoko umphumo unokusetyenziswa ngokuthe ngqo kwezinye izibalo.
Ezi zibalo zingabandakanya ixabiso ezifana nobude benkonzo yomsebenzi okanye ipesenti ehlawulwayo kwiinkqubo zonyaka ezipheliswa kusasa - njengezibonelelo zezempilo.
01 ngo-06
Umsebenzi we-YEARFRAC we-Syntax kunye neeArguments
I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano .
I-syntax yomsebenzi we-YEARFRAC ngu:
= YEARFRAC (Qala_kuqala, Qeda_date, Basis)
Qala_data - (efunekayo) ukuhluka kwexesha lokuqala. Le ngxabano ingaba yereferensi yeseli kwendawo yedatha kwiphepha lokusebenzela okanye umhla wokuqala wokuqala kwifom yefayili yecala .
I-End_date - (efunekayo) yesibili somhla. Iimfuno ezifanayo zengxoxo zisebenza njengalezo ezichazwe kwi- Start_date
Isiseko - (okukhethwa kukho) Ixabiso elivela kwi-zero ukuya kwezine elitshela i-Excel ukuba yeyiphi indlela yokubala yemini yokusebenzisa nomsebenzi.
- 0 okanye ukushiywa - iintsuku ezingama-30 ngenyanga / 360 ngosuku ngonyaka (US NASD)
1 - Inani lenani leentsuku ngenyanga / Inani lenani leentsuku ngonyaka
2 - Inani lenani leentsuku ngenyanga / 360 iintsuku ngonyaka
3 - Inani lenani leentsuku ngenyanga / 365 iintsuku ngonyaka
4 - 30 iintsuku ngenyanga / 360 iintsuku ngonyaka (iYurophu)
Amanqaku:
- YEARFRAC ibuyisela i-#VALUE! Ixabiso lephutha xa i-Start_date okanye i-End_date ayilona imihla efanelekileyo
- YEARFRAC ibuyisela i-#NUM! Ixabiso lephutha xa iNgxabano yesiseko ingaphantsi kwezinga okanye ngaphezulu kwezine
- Kwezikhetho ezikhoyo malunga nengxabano esekelwe, ixabiso le-1 linika ichanekileyo kwiintsuku nganye ngenyanga kunye neentsuku ngonyaka
- Olunye ulwazi malunga neSingqinisiso esisezantsi sisinikwe ekupheleni kwenkqubo yokufundisa
02 we-06
Umzekelo Usebenzisa umsebenzi we-YEARFRAC ye-Excel
Njengoko kunokubonwa kumfanekiso ongentla, lo mzekelo uya kusebenzisa umsebenzi we-YEARFRAC kwiseli E3 ukufumana ubude bexesha phakathi kwemihla emibini-ngoMatshi 9, 2012, noNovemba 1, 2013.
Umzekelo usebenzisa ukusetyenziswa kweetekisi kwendawo yokuqala nokuphela kwemihla kuba ziqheleke lula ukusebenza ngaphandle kokungena manani omhla wee-serial.
Emva koko, inyathelo lokuzikhethela lokunciphisa inani leendawo zokugqibela kwimpendulo ukusuka kwi-9 ukuya kweyesibini usebenzisa umsebenzi we- ROUND uya kwongezwa kwi-cell E4.
03 we-06
Ukufaka i-Tutorial Data
Qaphela: Iingxoxo zokuqalisa nokugqibela ziza kufakwa kusetyenziswa umsebenzi we-DATE ukukhusela iingxaki ezinokuthi zenzeke ukuba imihla iguqulelwa njengedatha yombhalo.
I-Cell - Idata D1 - Qala: D2 - Qedela: D3 - Ubude bexesha: I-D4 - Impendulo ephakamileyo: E1 - = UMHLA (2012,3,9) E2 - = UMHLA (2013,11,1)- Faka idatha elandelayo kwiiseli D1 ukuya ku-E2. Iiseli ze-E3 kunye ne-E4 ziindawo zefomula ezisetyenziswe kumzekelo
04 we-06
Ukufaka umsebenzi we-YEARFRAC
Eli candelo le-tutorial lingena kumsebenzi we-YEARFRAC kwiseli ye-E3 kwaye ibala ixesha phakathi kwemihla emibini kwifom ye-decimal.
- Cofa kwifowuni E3 - yilapho iziphumo zomsebenzi ziza kuboniswa
- Cofa kwiTrafom ithebhu yemenyu yebhondi
- Khetha usuku kunye nexesha kwi-Ribbon ukuvula uluhlu lwehla lokuhla
- Cofa kwi- YEARFRAC kuloluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi
- Kwibhokisi yencoko, nqakraza kwi- Start_date line
- Cofa kwiseli E1 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko
- Cofa kumgca weDatha_datha kwibhokisi yencoko
- Cofa kwiseli E2 kwiphepha lokusebenzela ukuze ufake ifowuni yesibini kwibhokisi yencoko
- Cofa kwiNgcaciso yomgca kwibhokisi yencoko
- Faka inombolo 1 kulo mgca ukuze usebenzise inani langempela leentsuku ngenyanga kunye nenani langempela leentsuku ngonyaka ekubaleni
- Cofa u-OK ukugqiba umsebenzi kwaye uvale ibhokisi yencoko
- Ixabiso le- 1.647058824 kufuneka livele kwiseli E3 ebudeni bexesha kwiminyaka phakathi kwemihla emibini.
05 ka 06
Ukuhlawula i-ROUND kunye ne-YEARFRAC Imisebenzi
Ukwenza umsebenzi ube lula ukusebenzisana nawo, ixabiso kwi-cell E3 linokujikelezwa kwiindawo ezimbini ezisetyenzisiweyo usebenzisa umsebenzi we-ROUND kwiseli ye-YEARFRAC kukuza kusebenza umsebenzi we-YEARFRAC ngaphakathi komsebenzi we-ROUND kwiseli E3.
Umphumo obangelwayo uza kuba:
= ROUND (YEARFRAC (E1, E2,1), 2)Impendulo yayiya kuba - 1.65.
06 we-06
Ulwazi lweNkcazelo yokuSebenza
Udibaniso oluhlukileyo lweentsuku ngenyanga kunye neentsuku ngonyaka ukwenzela ukuba i-argument ingumsebenzi we-YEARFRAC iyatholakala ngenxa yamashishini kwiindawo ezahlukeneyo-ezifana nokuthengwa kwamashishini, ezoqoqosho, kunye nezemali-baneemfuno ezahlukileyo kwiinkqubo zabo zokuphendula.
Ngokumisela inani leentsuku ngenyanga, iinkampani zinokukwenza ukuthelekiswa kwenyanga nokuthelekiswa kwenyanga okungeke kwenzeke ukuba inani leentsuku ngenyanga lingaba lisukela kwi-28 ukuya ku-31 ngonyaka.
Kwiinkampani, ezi ngxubusho zingaba yinzuzo, iindleko, okanye kwimeko yenkxaso yemali, inani lemali efunyenwe kutyalo-mali. Ngokufanayo, ukulinganisa inani leentsuku ngamnye ngonyaka kuvumela ukuqhathaniswa konyaka kwedatha. Iinkcukacha ezongezelelweyo
I-US (i-NASD - uMbutho weSizwe wezoThengisa iimpahla).
- Ukuba i- Start_date ngumhla wokugqibela wenyanga, iyalingana nomhla we-30 wenyanga enye.
- Ukuba i- End_date ingumhla wokugqibela wenyanga kwaye i- Start_date ingaphaya kwelanga le-30 lwenyanga, i- End_date iyafana no-1 ngosuku lwenyanga ezayo; ngenye indlela, i- End_date ilingana nomhla we-30 wenyanga enye
Indlela yaseYurophu:
- I-Start_dates kunye ne- End_idates ezenzeka ngomhla wama-31 wenyanga zilingana nomhla we-30 wenyanga enye.