Kushandisa DATEDIF kuverenga Mazuva, Mwedzi, kana Makore muExcel

Verengai nguva iyo kana musiyano pakati pamazuva maviri

Excel ine zviverengero zvakavakwa mumabasa emazuva anogona kushandiswa kuverenga nhamba yemazuva pakati pematambo maviri.

Zuva roga roga basa rinoita basa rakasiyana kuitira kuti zvigumisiro zvisiyana kubva kune rimwe basa kune rinotevera. Iyo yaunoshandisa, saka, inobva pane zvaunoda.

DATEDIF basa rinogona kushandiswa kuverenga nguva kana musiyano pakati pamazuva maviri. Nguva ino nguva inogona kuverengwa mu:

• mazuva
• mwedzi yakazara
• makore ose

Zvishandiso zvebasa iri zvinosanganisira kuronga kana kunyora zvirongwa zvekuziva nguva yenguva yemberi. Inogonawo kushandiswa, pamwe nezuva rekuzvarwa kwemunhu, kuverenga makore ake mumakore, mwedzi, uye mazuva .

Shanduro yeDATEDIF Function neArguments

Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .

Izwi rechirevo cheDATEDIF chinonzi:

= DATEDIF (start_date, end_date, unit)

start_date - (inoda) zuva rokutanga yenguva yakasarudzwa. Iyo chaiyo yekutanga zuva inogona kupindirwa nekuda kweiyo mhinduro kana kuti sero rinotarisa kunzvimbo yedata iyi mune pepa rekushandisa rinogona kupinda panzvimbo.

end_date - (inoda) zuva rokupedzisira kwenguva yakasarudzwa. Sezvakaita neKutanga_date, pinda zuva rekupedzisira chaiyo kana kuti sero rinotarisa panzvimbo ye data iyi mune pepa rekushanda.

chikwata (chaimbova chinonzi nguva) - (chinodiwa) chinotaurira basa kuti uwane nhamba yemazuva ("D"), mwedzi yakazara ("M"), kana kuti makore akazara ("Y") pakati pemitambo miviri.

Notes:

1. Excel inotora nguva yekuverenga kuburikidza nokushandura mazuva acho kuva nhamba dzematare , iyo inotanga pa zero musi wekutaura musi waJanuary 0, 1900 pane Windows makombiyuta neJanuary 1, 1904 pamakombiyuta eMacintosh.
2. Iyo unit argument inofanira kunge yakapoteredzwa nemashoko ekuti "D" kana "M".

Zvimwe pamusoro peChikamu Argument

Sangano rinopikisana rinogonawo kuva nemubatanidzwa wemazuva, mwedzi, nemakore kuitira kuti uwane nhamba yemwedzi pakati pemitambo miviri mugore rimwechete kana nhamba yemazuva pakati pemitambo miviri mumwedzi iwoyo.

• "YD" - inotara nhamba yemazuva pakati pemitambo miviri sekuti kana mazuva acho ari mugore rimwe chete (mutsara 5 pamusoro).
• "YM" - inotara nhamba yemwedzi pakati pemitambo miviri sekuti kana mazuva acho ari mugore rimwechete (mutsara 6 pamusoro).
• "MD" - inotara nhamba yemazuva pakati pemitambo miviri sekuti kana mazuva acho ari mumwedzi mumwechete uye gore (mutsetse 7 pamusoro).

DATEDIF Function Error Values

Kana nhoroondo yezvikonzero zvakasiyana-siyana zvebasa iri isina kupinda nenzira yakarurama iyo inotevera kukanganisa maitiro inowanikwa muchitokisi umo DATEDIF inoshanda:

• #VALUE! kukanganisa - kunodzoka kana kana kutanga- kutora kana kuguma_zvakaitika hazvisi mazuva chaiwo (mutsara 8 kumusoro, apo sero reA8 rine mashoko akanyorwa).
• #NUM! kukanganisa - kudzoka kana kuguma _date iri zuva rekare kupfuura kutanga_date (mutsara 9 pamusoro).

Muenzaniso: Verengai Kusiyana pakati Pemazuva maviri

Chimwe chinhu chinonakidza pamusoro peDATEDIF ndechekuti chinhu chakavanzwa pakuti hachina kunyorwa kune rimwe zuva Rinoita basa pasi pefomula tab muExcel, zvinoreva:

1. hapana huna bhokisi rebhokisi rinowanikwa pakupinda mubasa uye nharo dzaro.
2. iyo argument tooltip haina kuratidzira nhaurirano urongwa apo zita rebasa rinowanikwa muchitokisi.

Somugumisiro, basa racho nemafungiro aro zvinofanira kupinda mumunhu kuitira kuti zvishandiswe, kusanganisira kuisa komma pakati pemagariro ega ega sekuparadzanisa.

DATEDIF Muenzaniso: Kuverenga Kusiyana mumazuva

Matanho ari pasi apa anokwanisa kupinda muDATEDIF basa riri muchitokisi B2 mumufananidzo uri pamusoro apa unoratidza nhamba yemazuva pakati pemasikati May 4, 2014 uye August 10, 2016.

1. Dzvanya pachitokisi B2 kuti uite sero rinoshandiswa - iyi ndiyo iyo nhamba yemazuva pakati pemasikati maviri icharatidzwa.
2. Tanga = datedif ( "muchipinda B2.
3. Dzvanya pachitokisi A2 kuti uite ino seferensi yesero seyokutanga- date argument for the function.
4. Tora comma ( , ) mu cell B2 inotevera sero renhoroondo A2 kuti ive separarator pakati pekutanga uye yechipiri nharo.
5. Dzvanya pane sero A3 mune pepadheetti kuti uise iyi seferensi sekupedzisira segumo_date argument.
6. Nyora yechipiri comma ( , ) inotevera sero reference A3.
7. Nokuda kwechikwata chinokonzera, nyora tsamba D mune zvinyorwa ( "D" ) kuti utaure basa ratinoda kuziva nhamba yemazuva pakati pematambudziko maviri.
8. Tora mababase ekuvhara ")".
9. Dhinda pikicha inopinda mubhokisi kuti upedze fomu.
10. Nhamba yemazuva - 829 - inofanira kuonekwa muchitokisi B2 chebasa rekushanda.
11. Paunenge uchinyora pa cell B2 yakakwana formula = DATEDIF (A2, A3, "D") inowanikwa mubhairi yepamusoro pane pepa pepaji.