I YEARFRAC basa , sezvarinoridzirwa nezita racho, rinogona kushandiswa kuwana chikamu chiduku chegore chinofananidzirwa nenguva iyo pakati pezuva maviri.
Imwe Excel inoshanda yekuwana nhamba yemazuva pakati pemitambo miviri inogumira kudzorera kukosha mumakore, mwedzi, mazuva, kana kusanganiswa kwevatatu.
Kuti ishandiswe mumatare anotevera., Kukosha uku zvino inofanira kushandurwa kuva fomu yepamusoro. YEARFRAC, kune rumwe rutivi, inodzorera musiyano pakati pemasikati maviri muchimakumi zvakagadzirwa nemaitiro - zvakadai sa165 years - saka chigumisiro chinogona kushandiswa zvakananga pane zvimwe kuverenga.
Aya maverengero angasanganisira maitiro akadai sehurefu hwebasa hwebasa kana kuti chikamu chekubhadharwa kwezvirongwa zvegore negore zvakagumiswa kare - zvakadai sehutano hwemagariro.
01 of 06
Basa re YEARFRAC Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara we YEARFRAC basa nderekuti:
= YEARFRAC (Start_date, End_date, Basis)
Start_date - (inodikanwa) zuva rokutanga rakasiyana. Iyi nharo inogona kuva sechitsauko chesarenda kune nzvimbo yedhesi mubasa rekushanda kana musi chaiyo wokutanga mu serial nhamba yefomati .
End_date - (inotarisirwa) yechipiri zuva rakasiyana. Izvozvi nharo dzinoshandiswa zvinoshandiswa sezviri izvo zvinotsanangurwa nokuda kweKutanga_date
Basis - (optional) Chinokosha kubva pa zero kusvika kune mana chinoudza Excel iyo zuva rekuverenga nzira yekushandisa nayo basa.
- 0 kana kusina - mazuva makumi matatu pamwedzi / 360 zuva rega (US NASD)
1 - Nhamba chaiyo yemazuva pamwedzi / Nhamba chaiyo yezuva nezuva
2 - Nhamba chaiyo yemazuva pamwedzi / 360 mazuva pagore
3 - Nhamba chaiyo yemazuva pamwedzi / mazuva 365 pagore
4 - 30 mazuva pamwedzi / 360 mazuva ese (Europe)
Notes:
- YEARFRAC inodzorera #VALUE! kukanganisa kunokosha kana Start_date kana End_date isiri mazuva chaiwo
- YEARFRAC inodzorera #NUM! kukanganisa kunokosha kana Mhemberero huru isiri pasi pezinga kana kupfuura kupfuura mana
- Kubva pane zvingasarudzwa zvinoenderana nheyo yepamusoro, kukosha kwe1 kunopa yakanyatsojeka kwekuverenga mazuva pamwedzi nemazuva ega
- Mamwe mashoko pamusoro peShanduko gakava anopiwa pamagumo emudzidzisi
02 of 06
Muenzaniso Uchishandisa Basa re YEARFRAC yeEcelcel
Sezvo zvinogona kuonekwa mumufananidzo uri pamusoro, muenzaniso uyu unoshandisa YEARFRAC basa muchitokisi E3 kuwana nguva yakareba pakati pemiti miviri - March 9, 2012, naNovember 1, 2013.
Muenzaniso unoshandisa kushandiswa kwemasero kune nzvimbo yekutangira uye yekuguma kwemazuva kubva kazhinji kazhinji zviri nyore kushanda nazvo kupinda kupinda seri seri dzedhi nhamba.
Zvadaro, danho rekuzvipira rokutapudza nhamba yezvigaro zvepamusoro mune mhinduro kubva papfumbamwe kusvika kune maviri uchishandisa basa reROUND richawedzerwa kune cell E4.
03 of 06
Kupinda Tutorial Data
Cherechedza: Mazuva ekutanga uye ekupedzisira nharo dzichapinda uchishandisa DATE basa kuti zvidzivirire zvinetso zvinogona kuitika kana mazuva acho achidudzirwa semashoko ekunyora.
Cell - Data D1 - Kutanga: D2 - Kupedzisa: D3 - Nguva yakareba: D4 - Mhinduro Yakakosha: E1 - = DATE (2012,3,9) E2 - = DATE (2013,11,1)- Isa data inotevera inhengo D1 kusvika E2. Mitsara E3 uye E4 ndiyo nzvimbo yemafomu anoshandiswa mumuenzaniso
04 of 06
Kupinda Basa re YEARFRAC
Ichi chikamu chekudzidzisa chinopinda YEARFRAC basa mumusero E3 uye inotarisa nguva iri pakati pemazuva maviri muchimiro chema decimal.
- Kira pa cell E3 - iyi ndiyo iyo migumisiro yebasa icharatidzwa
- Dzvanya paMafomu yebhu yebhoni yebhoni
- Sarudza Zuva uye Nguva kubva kubhoni kuti uzarure basa rinoyerera pasi
- Dzvanya pa YEARFRAC mune urongwa kuti urere bhokisi rebasa rebasa
- Mubhokisi rebhokisi, tanga paIndaneti_kutanga
- Dzvanyira pa cell E1 mubasa rekushanda kuti uise seferensi yese mubhokisi rebhokisi
- Dzvanya paGumo_date mubhokisi rebhokisi
- Dzvanya pane cell E2 mubasa rekushandisa kuti uise seferensi yesero mubhokisi rebhokisi
- Dzvanya paNheyo yekutanga mubhokisi rebhokisi
- Pinda nhamba 1 iri munharaunda iyi kuti ushandise nhamba chaiyo yemazuva pamwedzi uye nhamba chaiyo yemazuva pagore kuverenga
- Dzvanya OK kuti upedze basa uye uvhare bhokisi rebhokisi
- Iko inosvika 1.647058824 inofanira kuonekwa muchitokisi E3 iyo yakareba nguva mumakore pakati pematambudziko maviri.
05 of 06
Kunyoresa ROUND ne YEARFRAC Mabasa
Kuita kuti basa riite nyore nyore kushanda naro, kukosha muchitokisi E3 kunogona kukomberedzwa kune nzvimbo mbiri dzinoshandiswa uchishandisa basa ROUND muchitokisi che YEARFRAC ndekushandira YEARFRAC basa mukati meROUND basa mumusero E3.
Iyo yakagadziriswa ichaita ndeyikuti:
= RONDO (YEARFRAC (E1, E2,1), 2)Mhinduro yacho ichange iri - 1.65.
06 of 06
Basis Argument Information
Kusiyana kwakasiyana kwemazuva pamwedzi uye mazuva nemakore kweChishanu nharo ye YEARFRAC basa inowanika nokuti mabhizimisi mune dzimwe nyika - sekugoverana kwekutengeserana, zvekugadzirisa, uye yezvemari-vane zvakasiyana siyana zvekuverenga maitiro avo.
Nokuenzanisa nhamba yemazuva pamwedzi, makambani anokwanisa kuita mwedzi kusvika mwedzi kuenzanisa kusingawanzoitiki kupiwa iyo nhamba yemazuva pamwedzi inogona kubva kubva pa28 kusvika ku31 mugore.
Kune makambani, kuenzanisira uku kungave kuri kune pfuma, mari, kana munyaya yemari yemari, muwandu wezvakawanikwa zvakakonzerwa nemari. Saizvozvowo, kuenzanisa nhamba yemazuva pagore kunobvumira kuenzaniswa kwemakore kwe data. Zvimwe zvinyorwa zve
US (NASD - National Association of Vatengesi Vepfumi) nzira:
- Kana iyo Start_date izuva rokupedzisira remwedzi, inenge yakaenzana nezuva re30 remwedzi iwoyo.
- Kana End_date iri zuva rekupedzisira remwedzi uye Start_date iripo kupfuura zuva re30 romwedzi, End_date inoenzana nezuva rekutanga romwedzi unotevera; zvisinei, End_date inoenzana nezuva re30 remwedzi iwoyo
Nzira yeEurope:
- Start_dates uye End_mashoko anoitika musi wegumi nemwedzi wemwedzi inoenzana nezuva re30 remwedzi iwoyo.