01 ea 01
Eketsa Likhoeli tsa Khoeli ho ea Matsatsi
ETSAHAHA Mosebetsi ka kakaretso
Mosebetsi oa EDATE oa Excel o ka sebelisoa ho eketsa ka potlako kapa ho tlosa likhoeli ho tsejoa matsatsi - tse kang ho hōla kapa matsatsing a matsete kapa matsatsing a qalang kapa a ho qetela a merero.
Kaha mosebetsi o eketsa kapa o tlosa likhoeli kaofela ho isa letsatsing, phello e tla lula e oela letsatsi le le leng la khoeli e le letsatsi la ho qala.
Linomoro tsa Serial
Boitsebiso bo khutlisitsoeng ke mosebetsi oa EDATE ke nomoro ea serial kapa letsatsi la serial. Etsa tlhahlobo ea letsatsi ho lisele tse nang le mosebetsi oa EDATE e le ho bontša matsatsi a hlakileng mosebetsing - o bontšitsoeng ka tlase.
Syntax ea Diketso le Mantsoe a EDATE
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .
Tlhaloso ea mosebetsi oa EDATE ke:
= EDATE (Start_date, Likhoeli)
Qala_date - (e hlokehang) letsatsi la qalo ea morero kapa nako eo ho buuoang ka eona
- tlhōlisano ena e ka ba letsatsi le kenngoa mosebetsing kapa selefouno ea sebaka seo data e sebetsang ho sona
Likhoeli - (tse hlokehang) - palo ea likhoeli pele kapa ka morao ho Qala
- tlhōlisano ena e ka ba bohlokoa bo kenngoa mosebetsing kapa selefouno ea sebaka seo data e sebetsang ho sona
- litekanyetso tse ntle li fana ka matsatsi a nakong e tlang - setšoantšo sa 8 setšoantšong se ka holimo
- litekanyetso tse fosahetseng tsa matsatsi a fetileng - mohala oa 3 setšoantšong se ka holimo
Haeba likhoeli e se palo e kholo, e na le truncated (karolo ea moralo e tlosoa) - joalo ka ha ho bontšitsoe moqolong oa 8 setšoantšong se ka holimo moo lilemo tse 12.25 li nkiloeng ho ea lekaneng 12
#VALUE! Phoso ea Boleng
Haeba khang ea Start_date e se letsatsi le utloahalang, mosebetsi o khutlisa #VALUE! palo ea phoso - joalokaha ho bontšitsoe moqolong oa 4 setšoantšong se ka holimo, ho tloha ka la 2/30/2016 (la 30 February, 2016) ha hoa nepahala
Excel's EDATE Function Mohlala
Joalokaha ho bontšitsoe setšoantšong se ka holimo, mohlala ona o sebelisa mosebetsi oa EDATE ho eketsa le ho ntša likhoeli tse sa tšoaneng ho fihlela ka la 1 January, 2016.
Boitsebiso bo ka tlase bo akaretsa mehato e sebelisetsoang ho kenya ts'ebetso ho lisele B3 le C3 ea leqephe la mosebetsi .
Ho kenya mosebetsi oa EDATE
Dikgetho bakeng sa ho kena mosebetsing le mabaka a eona a kenyeletsa:
- Tšoara mosebetsi o feletseng: = EDATE ($ A $ 3, C2) ka seleng ea C3;
- Ho khetha mosebetsi le mabaka a eona ho sebelisa EDATE mosebetsi oa lebokose la lihlooho.
Le hoja ho ka khoneha ho thathamisa mosebetsi o feletseng ka letsoho, batho ba bangata ba fumana ho le bonolo ho sebelisa lebokose la lebokose ho kenya lintlha tse sebetsang.
Mehato e ka tlaase ho sekoahelo kena ka EDATE mosebetsi o bontšitsoeng seleng ea B3 setšoantšong ka holimo ho sebelisa lebokose la lebokose la mosebetsi.
Kaha litekanyetso tse lokelang ho kenngoa bakeng sa likhohlano tsa Likhoeli li fosahetseng (-6 le -12) matsatsi a lisele tsa B3 le C3 e tla ba pejana ho letsatsi la qala.
Mohlala oa EDATE - Likhoeli tse tlohang
- Tobetsa seleng ea B3 - ho e etsa sele e sebetsang;
- Tobetsa Letomong tab ea lente;
- Tobetsa ka mesebetsi ea Letsatsi le Nako ho bula lenane la ho theola lethathamo;
- Tobetsa ho HLAHISA lenaneong ho hlahisa lebokose la lebokose la mosebetsi;
- Tobetsa ho Start_date line ho lebokoseng la lebokose;
- Tobetsa ho seleng ea A3 lefapheng la mosebetsi oa ho kenya lengolo leo la lihlooho ka lebokoseng la lebokose le leqhoa la Start_date ;
- Tobetsa konopo ea F4 ka lebokose ho etsa A3 sebaka se feletseng sa lisele- $ A $ 3;
- Tobetsa ho Likhoeli tsa Likhoeli lebokoseng la lebokose;
- Tobetsa ho cell B2 kahare ea ho kenya lengolo leo la lihlooho ka lebokose la lebokose le le ngangano ea Likhoeli ;
- Tobetsa OK ho qeta mosebetsi le ho khutlela mosebetsing;
- Letsatsi la 7/1/2015 (la 1 July, 2015) - le hlaha ka seleng ea B3 e leng likhoeli tse tšeletseng pele letsatsi la qala;
- Sebelisa sebetsana ho tlitsa EDATE mosebetsi ho seleng C3 - letsatsi la 1/1/2015 (January 1, 2015) le lokela ho hlaha ka seleng ea C3 e leng likhoeli tse 12 pele letsatsi la qala;
- Haeba u tobetsa seleng ea C3 mosebetsi o feletseng = EDATE ($ A $ 3, C2) e hlaha kahare ea foromo ka holim'a leqephe la mosebetsi;
Tlhokomeliso : Haeba palo, e kang 42186 , e hlaha seleng ea B3 ho ka etsahala hore seleng e na le mekhoa e tloaelehileng e fetisitsoeng ho eona. Sheba litaelo tse ka tlase ho fetola sele hore u etse mokhoa oa ho etsa joale;
Ho fetola Letsatsi Format ho Excel
Tsela e potlakileng le e bonolo ea ho fetola mokhoa oa letsatsi bakeng sa lisele tse nang le EDATE mosebetsi ke ho khetha e le mong lethathamong la likhetho tsa ho etsa litlhahiso pele ho setho ka lebokoseng la dialog cells . Mehato e ka tlase e sebelisa motsoako oa mekhoa ea khetho ea keyboard ea Ctrl + 1 (nomoro ea 1) ho bula lebokose la boitsebiso la lihlooho tsa Format .
Ho fetoha ho ea ka mokhoa oa letsatsi:
- Totobatsa lisele tse leng lethathamong la litaba tse nang le tsona kapa tse tla ba le matsatsi
- Tobetsa linotlolo tsa Ctrl + 1 ho bula lebokose la lebokose la lihlooho tsa Format
- Tobetsa ho Taba ea lebokose la lebokose la lihlooho
- Tobetsa ka Letsatsi lethathamong la lethathamo la sehlopha (lehlakoreng le letšehali la lebokose la lebokose)
- Ka fensetere ea mofuta (ka lehlakoreng le letona), tobetsa mohla oa letsatsi o lakatsehang
- Haeba lisele tse khethiloeng li na le boitsebiso, lebokose la Sample le tla bontša ponelo-pele ea mofuta o khethiloeng
- Tobetsa konopo ea OK ho boloka phetoho e fetohileng le ho koala lebokose la lebokose
Bakeng sa ba khethang ho sebelisa mouse ho e-na le lebokose, mokhoa o mong oa ho bula lebokose la lebokose ke ho:
- Tobetsa ka ho toba lisele tse khethiloeng ho bula menyetla ea moelelo
- Khetha Mefuta ea Fomoro ... ho tswa ho menyetla ho bula lebokose la lihlooho tsa boitsebiso
###########
Haeba, ka mor'a ho fetola mokhoa oa letsatsi bakeng sa sele, sele e bonts'a marang-rang a li-hashi, hobane sele ha e na bophara bo lekaneng ho bontša data e hlophisitsoeng. Ho atolosa sele ho tla lokisa bothata.