Bala nako ea hau ea khale le mosebetsi oa Excel DATEDIF

U hloka ho tseba lilemo tsa hau (kapa motho e mong?)

Tšebeliso e 'ngoe bakeng sa mosebetsi oa Excel oa DATEDIF ke ho bala nako ea motho ea hona joale. Sena se thusa maemong a sa tšoaneng.

Bala nako ea hau ea khale le DATEDIF

Ka mokhoa o latelang, mosebetsi oa DATEDIF o sebelisetsoa ho khetholla lilemo tsa morao tsa motho ka lilemo, likhoeli le matsatsi.

= DATEDIF (E1, TODAY (), "Y") & "Lilemo," & DATEDIF (E1, TODAY (), "YM") &
"Likhoeli," & DATEDIF (E1, TODAY (), "MD") & "Matsatsi"

Tlhokomeliso : Ho etsa hore mokhoa ona o be bonolo ho sebetsana le oona, letsatsi la tsoalo la motho le kenngoa ka seleng ea E1 ea leqephe la mosebetsi. Tlhaloso ea sele ea sebaka sena e kenngoa ka mokhoa ona.

Haeba u na le letsatsi la tsoalo le bolokiloeng selekaneng e fapaneng leqepheng la mosebetsi , etsa bonnete ba hore u fetola litšupiso tsa lisele tse tharo ka foromo.

Ho senya Tlhahlobo

Tobetsa setšoantšong se ka holimo ho se eketsa

Morero o sebelisa DATEDIF ka makhetlo a mararo ka foromong ho bala palo ea lilemo, joale palo ea likhoeli, ebe joale palo ea matsatsi.

Likarolo tse tharo tsa foromo ke:

Palo ea Lilemo: DATEDIF (E1, TODAY (), "Y") & "Lilemo" Nako ea Likhoeli: DATEDIF (E1, TODAY (), "YM") & "Likhoeli" Palo ea Matsatsi: DATEDIF (E1, TODAY ( ), "MD") & "Matsatsi"

Ho lumellana le mokhoa o kopaneng

Ampandand (&) ke letšoao la concatenation ka Excel.

Tšebeliso e 'ngoe bakeng sa concatenation ke ho kopanya lintlha tsa nomoro le ho romella data hammoho ha li sebelisitsoe hammoho ka mokhoa o le mong.

Ka mohlala, ampersand e sebelisetsoa ho kopanela mosebetsing oa DATEDIF le "Years", "Months" le "Matsatsi" likarolong tse tharo tsa foromo e bontšitsoeng ka holimo.

Mosebetsi oa kajeno ()

Morero o boetse oa sebelisa mosebetsi oa TODAY () ho kenyelletsa letsatsi la hona joale ka mokhoa oa DATEDIF.

Kaha mosebetsi oa kajeno () o sebelisa letsatsi la likarolo tsa mochine hore o fumane letsatsi la morao-rao, mosebetsi o tsoela pele ho itsosa nako le nako ha setšoantšo se khutlisetsoa hape.

Ka tloaelo lipampiri tsa mosebetsi li khutlisetsa nako le nako ha li buloa e le hore lilemo tsa morao-rao tsa motho li tla eketseha letsatsi le leng le le leng hore leqephe la lipampiri le bulehe ntle le hore mokhoa oa ho khutlisetsa morao o tlosoe.

Mohlala: Bala kopo ea hau ea khale le DATEDIF

1. Kenya letsatsi la tsoalo ea hau ho kenya seleng ea E1 ea selefouno
2. Mofuta = KAJENO () ho seleng ea E2. (Ho ikhethela). E bonts'a letsatsi la morao tjena le bonngoeng setšoantšong se ka holimo, Sena ke sa hau feela sefahleho sa hau, data ena ha e sebelisoe ke foromo ea DATEDIF ka tlase
3. Tlanya foromo e latelang ka seleng ea E3
4. = DATEDIF (E1, TODAY (), "Y") & "Lilemo," & DATEDIF (E1, TODAY (), "YM") & "Likhoeli,"
   & DATEDIF (E1, TODAY (), "MD") & "Matsatsi"

   Tlhokomeliso : Ha u kenya boitsebiso bo ngotseng ka mokhoa o lokelang ho kenngoa ka matšoao a mabeli a quotation a kang "Lilemo."

5. Tobetsa konter ENTER ho lebokose
6. Lilemo tsa hau tsa joale li lokela ho hlaha seleng ea E3 ea leqephe la mosebetsi.
7. Ha o tobetsa seleng ea E3 mosebetsi o feletseng o hlaha kahare ea foromo ka holim'a leqephe la mosebetsi