Ayyukan aikin YEARFRAC na Excel

Aikin YEARFRAC, kamar yadda sunansa ya nuna, za'a iya amfani dashi don gano wane ɓangare na shekara yana wakiltar lokacin lokaci tsakanin kwana biyu.

Wasu ayyuka na Excel don gano yawan kwanakin tsakanin kwana biyu suna iyakance ga dawo da darajar a kowace shekara, watanni, kwanakin, ko haɗuwa na uku.

Don amfani da su a cikin lissafi na ƙarshe, wannan darajar to dole ne a canza shi zuwa nau'i na decimal. SARINAR, a gefe guda, ya sake bambanci tsakanin kwanakin biyu a cikin nau'i-nau'i na atomatik ta atomatik - kamar shekaru 1.65 - don haka za'a iya amfani da sakamakon a cikin wasu lissafin.

Wadannan lissafin zasu iya haɗawa da dabi'u kamar ma'aikaci na tsawon sabis ko yawan da za a biya don shirye-shiryen shekara-shekara da aka ƙare farkon - kamar amfanin lafiyar jiki.

01 na 06

Sakamakon Sakamakon YEARFRAC da Magana

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

Haɗin aikin aikin YEARFRAC shine:

= YEARFRAC (Fara_date, End_date, Basis)

Fara_date - (da ake buƙata) samfuri na farko. Wannan jayayya na iya kasancewa hanyar tantancewar salula zuwa wurin da aka sanya bayanai a cikin takarda aiki ko kwanan farawar kwanan wata a cikin tsarin lambobi .

End_date - (da ake buƙata) na lamba na biyu. Haka sharuɗɗan shawarwari suna amfani da su kamar yadda aka tsara don Fara_date

Basis - (zaɓuɓɓuka) A darajar tazarar daga sifilin zuwa hudu da ke nuna Excel wanda shine hanyar ƙidayar rana don amfani tare da aikin.

1. 0 ko tsallake - kwanaki 30 a kowace wata / 360 rana a kowace shekara (US NASD)
   1 - Lambobi na ainihi kwanan wata / Lambar kwanan wata ta kowace shekara
   2 - Lambobi na ainihi a kowace wata / 360 a kowace shekara
   3 - Yawan lokuttan kwanan wata na wata / 365 a kowace shekara
   4 - 30 kwana a kowace wata / 360 days kowace shekara (Turai)

Bayanan kula:

• SHEWAR YEARFRAC ya dawo #VALUE! kuskuren kuskure idan Start_date ko End_date ba su dace ba
• SHEWAR YEARFRAC ya dawo #NUM! kuskuren kuskure idan hujjar Basis ta kasa da siffar ko fiye da hudu
• Daga cikin zaɓuɓɓukan da aka samo don gardamar basira, darajar 1 tana bada mafi yawan ƙidayar kwanakin kowace wata da kwanakin kowace shekara
• Ƙarin bayani game da shaidar Basis an ba a ƙarshen koyawa

02 na 06

Misali Yin amfani da aikin YEARFRAC na Excel

Kamar yadda aka gani a cikin hoton da ke sama, wannan misali zai yi amfani da aikin YEARFRAC a cikin cell E3 don gano tsawon lokaci tsakanin kwanaki biyu - Maris 9, 2012, da Nuwamba 1, 2013.

Misali na yin amfani da tantanin halitta ya danganta da wuri na farkon da ƙare kwanaki tun lokacin da sukan fi sauƙin aiki tare da shigar da lambobin kwanan wata.

Kashi na gaba, zabin da za a rage don rage adadin wurare mara kyau a cikin amsa daga tara zuwa biyu ta yin amfani da aikin ROUND za a kara zuwa cell E4.

03 na 06

Shigar da Bayanan Tutorial

Note: Za a shigar da tambayoyi na farko da na ƙarshe ta amfani da DATE don hana matsalolin da za su iya faruwa idan an fassara kwanakin a matsayin rubutu na rubutu.

Cell - Data D1 - Fara: D2 - Gama: D3 - Tsayi na tsawon lokaci: D4 - Amsar Rame: E1 - = DATE (2012,3,9) E2 - = DATE (2013,11,1)

1. Shigar da wadannan bayanan cikin sel D1 zuwa E2. Sel na E3 da E4 sune wuri don tsarin da aka yi amfani dashi a misali

04 na 06

Shigar da aikin YEARFRAC

Wannan sashe na koyawa na shiga aikin YEARFRAC cikin tantanin halitta E3 kuma yana ƙayyade lokacin tsakanin kwanakin biyu a cikin nau'i-nau'i.

1. Danna kan salula E3 - wannan shine inda za a nuna sakamakon aikin
2. Danna maɓallin Formulas na shafin rubutun
3. Zabi Kwanan wata da lokaci daga riƙabben don buɗe jerin aikin sauke aikin
4. Danna kan YEARFRAC a jerin don kawo akwatin maganganun aikin
5. A cikin akwatin maganganu, danna kan Fara_date line
6. Danna kan tantanin halitta E1 a cikin takardar aiki don shigar da tantanin halitta a cikin akwatin maganganu
7. Danna kan layin Ƙarshe a cikin akwatin maganganu
8. Danna kanfikan E2 a cikin takardun aiki don shigar da tantanin halitta a cikin akwatin maganganu
9. Danna maɓallin Basis a cikin akwatin maganganu
10. Shigar da lambar 1 a kan wannan layin don amfani da ainihin lambobin kwanaki da wata da ainihin adadin kwanaki a kowace shekara a lissafi
11. Danna Ya yi don kammala aikin kuma rufe akwatin maganganu
12. Darajar 1.647058824 ya kamata ya bayyana a cikin cell E3 wanda shine tsawon lokaci a cikin shekaru tsakanin kwanakin biyu.

05 na 06

Nesting da ROUND da ayyukan YEARFRAC

Don yin sakamako mai sauki don yin aiki tare da, ƙimar tantanin halitta E3 za a iya zagaye zuwa wurare biyu na ƙirawa ta yin amfani da aikin ROUND a tantanin halitta na YEARFRAC shine ya yi aikin aikin YEARFRAC a cikin aikin ROUND a cikin cell E3.

Ma'anar wannan tsari shine:

= ROUND (YEARFRAC (E1, E2,1), 2)

Amsar ita ce - 1.65.

06 na 06

Bayanin Bayani na Bayani

Hanyoyin daban-daban na kwana a kowace wata da kwana a kowace shekara don shaida na Basira na aikin YEARFRAC suna samuwa saboda kasuwanci a wasu fannoni - irin su raba cinikayya, tattalin arziki, da kuma kudi - suna da bukatun daban-daban don tsarin tsarin su.

Ta hanyar ƙayyade adadin kwanakin kowace wata, kamfanoni zasu iya yin wata ɗaya zuwa watanni wanda ba za a iya ba da shi ba don yawan lokuttan kwanakin wata zai iya kasancewa daga 28 zuwa 31 a cikin shekara ɗaya.

Ga kamfanonin, waɗannan kwatancen na iya zama don riba, kudade, ko kuma a cikin yanayin kudi, yawan adadin da aka samu a kan zuba jari. Hakazalika, daidaitaccen adadin kwanaki a kowace shekara yana ba da damar kwatanta bayanan shekara. Karin bayani don

US (NASD - Ƙungiyar Ƙungiyar Ƙungiyar Tsararraki) hanya:

• Idan Fara_date ita ce rana ta ƙarshe ta wata, zai zama daidai da ranar 30 ga wannan watan.
• Idan End_date ita ce rana ta ƙarshe na wata daya kuma Fara_date ya kasance a baya fiye da ranar 30 ga wata, End_date ya zama daidai da ranar 1 ga watan mai zuwa; In ba haka ba, End_date ya zama daidai da ranar 30 ga wannan watan

Hanyar Turai:

• Fara_dates da End_dates wanda ya faru a ranar 31 ga wata ya zama daidai da ranar 30 ga wannan watan.