Verenga Current Current Age neExcel DATEDIF Function

Unoda kuziva makore ako (kana mumwe munhu?)

Imwe shandiso yeExcel yeDATEDIF basa ndeyekuverenga nguva yemunhu. Izvi zvinobatsira mune zvakasiyana-siyana mamiriro ezvinhu.

Verenga Current Current Age neDATEDIF

Muchidimbu chinotevera, DATEDIF inoshandiswa kutsvaga makore evanhu iye zvino mumakore, mwedzi nemazuva.

= DATEDIF (E1, TODAY (), "Y") & "Makore," & DATEDIF (E1, TODAY (), "YM") &
"Mwedzi," & DATEDIF (E1, TODAY (), "MD") & "Mazuva"

Cherechedza : Kuita kuti iri nyore nyore kushanda nayo, zuva rekuzvarwa kwomunhu rakapinda muchitokisi E1 chebasa rekushanda. Tsanangudzo yesero pane iyi nzvimbo yakabva yangopinda mumutambo.

Kana iwe une zuva rekuberekwa rakachengetwa mune rimwe sero riri mune pepa rekushanda , iva nechokwadi chekushandura zvitatu zvinyorwa zvinyorwa mumutsetse.

Kuputsa Puremu

Dzvanya pamufananidzo uri pamusoro kuti uwedzere

Chirevo chacho chinoshandisa DATEDIF katatu mumutsetse kuti uverenge kutanga nhamba yemakore, ipapo nhamba yemwedzi, uye ipapo nhamba yemazuva.

Idzi nhengo nhatu dzomuti ndiwo:

Nhamba Yemakore: DATEDIF (E1, TODAY (), "Y") & "Makore" Nhamba Yemwedzi : DATEDIF (E1, TODAY (), "YM") & "Mwedzi" Nhamba Yemazuva: DATEDIF (E1, TODAY ( ), "MD") & "Mazuva"

Kugadzirisa Mutemo Wekubatana

The ampersand (&) chiratidzo chekubvumirana muExcel.

Imwe shanduro yekubvumirana ndeyekubatanidza deta yepafoni uye kunyora deta pamwe chete kana iko kushandiswa pamwe chete mumusara mumwe chete.

Somuenzaniso, ampersand inoshandiswa kubatana nebasa reDATEDIF kumashoko okuti "Makore", "Mwedzi", uye "Mazuva" muzvikamu zvitatu zvemufananidzo wakaratidzwa pamusoro apa.

Nhasi () Basa

Nzira yacho inoshandisawo TODAY () basa kuti uise zuva ranhasi iri mumhando yeDATEDIF.

Kubvira pazviri nhasi () basa rinoshandisa musi wepakombiyuta kuti iwane zuva razvino, basa racho rinoramba richizvishandura nguva dzose apo pepa rekushandura rinodzokororwa zvakare.

Kazhinji mapepa ekushandura anoyevedza nguva dzose paanenge avhurwa kuitira kuti munhu wemakore aripo anozowedzera zuva rega roga kuti pepa rekushandura rinovhurwa kunze kwekugadziriswa kwekugadziriswa kwekugadzirisa.

Muenzaniso: Tora Nguva Yenyu Yakare neDATEDIF

1. Isa zuva rako rokuberekwa muchitokisi E1 chebasa rekushanda
2. Tanga = TODAY () muchitokisi E2. (Zvichida). Inoonesa zuva rekuonekwa sezvinoonekwa mumufananidzo uri pamusoro, Izvi ndezvenhare yako chete, iyi deta haisati yashandiswa nemhando DATEDIF iri pasi apa
3. Tora fomu iyi inotevera mu cell E3
4. = DATEDIF (E1, TODAY (), "Y") & "Makore," & DATEDIF (E1, TODAY (), "YM") & "Mwedzi,"
   & DATEDIF (E1, TODAY (), "MD") & "Mazuva"

   Cherechedza : Paunenge uchinyorera dhidhii mumugadziro unofanirwa kuiswa mukati memashoko maviri ezvinyorwa zvakadai se "Makore."

5. Dhinda iri ENTER kiyi pane keyboard
6. Nguva yako yemazuva ano inofanira kuonekwa muchitokisi E3 chebasa rekushanda.
7. Paunenge uchinge uri pa cell E3 basa rakakwana rinowanikwa mubhairi yepamusoro pane pepa pepaji