Sungani Zaka Zanu Zamakono ndi Ntchito ya Excel DATEDIF

Muyenera kudziwa zaka zanu (kapena za wina?)

Ntchito imodzi ya ntchito ya Excel ya DATEDIF ndiyo kuwerengera zaka za munthu. Izi ndi zothandiza pazochitika zosiyanasiyana.

Sungani Zaka Zanu Zamakono ndi DATEDIF

Mu njira yotsatirayi, ntchito ya DATEDIF imagwiritsidwa ntchito kudziwa zaka za munthu zomwe zikuchitika m'zaka, miyezi ndi masiku.

= DATEDIF (E1, TODAY (), "Y") & "Zaka," & DATEDIF (E1, TODAY (), "YM") &
"Miyezi," & DATEDIF (E1, TODAY (), "MD") & "Masiku"

Zindikirani : Kuti mupange kuti njirayi ikhale yosavuta kugwira ntchito, tsiku la kubadwa kwa munthu lilowetsedwa mu selo E1 la kapepala. Kutanthauzira kwa selo kwa malowa kenaka kudapangidwira.

Ngati muli ndi tsiku lobadwira lomwe liri mu selo losiyana pa tsamba , yesetsani kusintha mafotokozedwe atatu omwe ali m'ndandanda.

Kuthetsa Mchitidwe

Dinani pa chithunzi pamwambapa kuti mukulitse

Fomuyi imagwiritsa ntchito DATEDIF katatu mu chiwerengero chowerengera chiwerengero cha zaka, ndiye chiwerengero cha miyezi, ndiyeno chiwerengero cha masiku.

Zotsatira zitatuzi ndi:

Chiwerengero cha zaka: DATEDIF (E1, TODAY (), "Y") & "Years" Chiwerengero cha miyezi: DATEDIF (E1, TODAY (), "YM") & "Miyezi" Number of Days: DATEDIF (E1, TODAY ( ), "MD") & "Masiku"

Kugwirizanitsa Mchitidwe Pamodzi

Ampersand (&) ndi chizindikiro cha concatenation mu Excel.

Ntchito imodzi yogwiritsira ntchito ndi kulumikiza deta ya nambala ndi kulembetsa deta palimodzi pamene imagwiritsidwa ntchito pamodzi mu njira imodzi.

Mwachitsanzo, ampersand amagwiritsidwa ntchito kuti agwirizane ndi ntchito ya DATEDIF ndi mawu akuti "Zaka", "Miyezi", ndi "Masiku" m'magulu atatu a chiganizo chomwe chili pamwambapa.

Lero () Ntchito

Fomuyi imagwiritsanso ntchito MASIKU ano () kugwira ntchito pakalipano tsiku la DATEDIF.

Kuyambira lero (ntchito) ikugwiritsira ntchito tsiku lachidule la makompyuta kuti lipeze tsiku lomwe likugwiritsidwa ntchito, ntchitoyo imasintha nthawi zonse pamene tsamba lakonzedwa.

Kawirikawiri mapepala apamanja amawongolera nthawi iliyonse yomwe atsegulidwa kotero kuti msinkhu wa munthu ukuwonjezeka tsiku lirilonse kuti pepala lamasamba litsegulidwe pokhapokha kukonzanso kokha kumatsekedwa.

Chitsanzo: Terengani Zaka Zanu Zamakono ndi DATEDIF

1. Lowetsani tsiku lanu lobadwira mu selo E1 la worksheet
2. Mtundu = MASIKU ano () mu selo E2. (Mwasankha). Kuwonetsera tsiku lomwe likuwonekera pa chithunzi pamwambapa, Izi ndizolemba zanu zokha, deta iyi siigwiritsidwe ntchito ndi DATEDIF fomu pansipa
3. Lembani ndondomeko zotsatirazi mu selo E3
4. = DATEDIF (E1, TODAY (), "Y") & "Zaka," & DATEDIF (E1, TODAY (), "YM") & "Miyezi,"
   & DATEDIF (E1, TODAY (), "MD") & "Masiku"

   Zindikirani : Mukamalemba deta muzondomekoyi iyenera kutsekedwa mu zizindikiro zamagwirizano monga "Zaka."

5. Onetsetsani ENTER yowonjezera pa kambokosi
6. Ukalamba wanu uyenera kuoneka mu selo E3 ya tsamba.
7. Mukasindikiza pa selo E3 ntchito yowonjezera imapezeka mu barre yazenera pamwamba pa tsamba