01 ya 01
Onjezerani / kuchotsani Miyezi Kufika pa Nthawi
Sungani ntchito Ntchito mwachidule
Ntchito ya EDATE ya Excel ikhoza kugwiritsidwa ntchito mwamsanga kuwonjezera kapena kuchotsa miyezi yodziwika ndi masiku - monga kukula kapena chifukwa cha nthawi ya ndalama kapena masiku oyambirira kapena mapeto a polojekiti.
Popeza ntchitoyi imangowonjezera kapena kuchotsa miyezi yonse mpaka tsiku, zotsatira zake zidzatha tsiku lomwelo la mwezi ngati tsiku loyamba.
Numeri Zakale
Deta yobwerezedwa ndi EDATE ntchito ndi nambala ya serial kapena tsiku lachidule. Lembani tsiku lopangidwira kwa maselo okhala ndi EDATE ntchito kuti asonyeze masiku ovomerezeka mu worksheet - tatchulidwa pansipa.
Syntax ndi Ntchito Zophatikiza za EDATE
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Mawu omasulira a EDATE ntchito ndi awa:
= DZIWANI (Yambani_kuyamba, Miyezi)
Yambani_date - (yofunikira) tsiku loyamba la polojekiti kapena nthawi yomwe ikufunsidwa
- Mtsutso uwu ukhoza kukhala tsiku limene linalowa mu ntchito kapena selo lofotokozera malo a deta mu tsamba la ntchito
Miyezi - (yofunika) - chiwerengero cha miyezi isanayambe kapena pambuyo pake
- Mtsutso uwu ukhoza kukhala phindu lolowetsedwa mu ntchito kapena selo loyang'ana pa malo a deta muzenera
- Miyezo yabwino imapereka masiku amtsogolo - mzere 8 mu chithunzi pamwambapa
- Zosasokoneza zaka zam'mbuyomu - mzere 3 mu chithunzi pamwambapa
Ngati miyezi siiliyonse, imayendetsedwa (gawo la decimal limachotsedwa) - monga momwe tawonedwera mzere 8 mu fano pamwamba pomwe zaka 12.25 zimadulidwa ku integer 12
#VALUE! Kulakwitsa kwa Mtengo
Ngati mkangano wa Start_date sunali tsiku lovomerezeka, ntchitoyo imabwerera #VALUE! Phindu lachinyengo - monga momwe tawonedwera mzere 4 mu chithunzi pamwambapa, kuyambira 2/30/2016 (February 30, 2016) ndilololedwa
Chitsanzo cha EDATE Chitsanzo cha Excel
Monga momwe tawonetsera pa chithunzi pamwambapa, chitsanzo ichi chikugwiritsa ntchito EDATE ntchito kuwonjezera ndikuchotsa miyezi ingapo mpaka tsiku la January 1, 2016.
Zomwe zili pansipa zikukhudza njira zomwe amagwiritsidwa ntchito polowera ntchito mu maselo B3 ndi C3 a worksheet .
Kulowa ntchito ya EDATE
Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:
- Kujambula ntchito yonse: = SANKHA ($ A $ 3, C2) mu selo C3;
- Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito EDATE ntchito dialog box.
Ngakhale kuti n'zotheka kungolemba ntchito yonseyo ndi dzanja, anthu ambiri amavutika kuti agwiritse ntchito bokosilo kuti ayambe kukambirana.
Masitepe omwe ali pansipa angalowe mu EDATE ntchito yomwe ikuwonetsedwa mu selo B3 mu chithunzi pamwamba pogwiritsa ntchito bokosi lazokambirana.
Popeza malingaliro oyenera kulowetsedweratu pamakangano a miyezi ndi olakwika (-6 ndi -12) tsikulo m'maselo B3 ndi C3 adzakhala oyambirira kuposa tsiku loyamba.
Chitsanzo cha EDATE - Miyezi Yotsitsa
- Dinani pa selo B3 - kuti mupange selo yogwira ntchito;
- Dinani pa Fomu tab ya riboni;
- Dinani pa Tsiku ndi Nthawi ntchito kuti mutsegule ntchito yolemba pansi mndandanda;
- Dinani Gwiritsani ntchito mndandanda kuti mubweretse bokosi lazokambirana;
- Dinani pa Start_date mzere mu bokosi la dialog;
- Dinani pa selo A3 mu tsambalo kuti mulowetse selololo mu bokosi la dialogso monga mtsutso wa Start_date ;
- Panikizani F4 key pa kibokosiko kuti A3 akhale mndandanda wa maselo - $ A $ 3;
- Dinani pa Mwezi mzere mu bokosi la dialog;
- Dinani pa selo B2 patsiku la ntchito kuti mulowetse selolo mu bokosi la dialogso monga mtsutso wa Miyezi ;
- Dinani OK kuti mutsirize ntchitoyi ndi kubwerera ku tsamba la ntchito;
- Tsiku la 7/1/2015 (July 1, 2015) - likupezeka mu selo B3 yomwe ili miyezi isanu ndi umodzi isanafike tsiku loyamba;
- Gwiritsani ntchito mankhwala okwanira kuti mufanizire EDATE ntchito ku selo C3 - tsiku la 1/1/2015 (January 1, 2015) liyenera kuoneka mu selo C3 yomwe ili miyezi 12 isanayambe tsiku;
- Ngati inu mutsegula pa selo C3 ntchito yonse = EDATE ($ A $ 3, C2) ikupezeka mu bar barula pamwamba pa tsamba;
Zindikirani : Ngati chiwerengero, monga 42186 , chimawonekera mu selo B3, ndiye kuti selo liri ndi maonekedwe aakulu. Onani malangizo apafupi kuti musinthe selo kuti muyambe kupanga maonekedwe;
Kusintha mtundu wa Date mu Excel
Njira yosavuta komanso yosavuta yosinthira fomu yamakono ya maselo okhala ndi EDATE ntchito ndi kusankha imodzi kuchokera mndandanda wazomwe mungakonzere maonekedwe anu mu bokosi la mauthenga a Format . Mapepala omwe ali m'munsimu amagwiritsira ntchito mndandanda wa njira yachinsinsi ya Ctrl + 1 (nambala imodzi) kutsegula bokosi la bokosi la Maonekedwe.
Kusintha ku mtundu wa tsiku:
- Onetsetsani maselo omwe ali pa tsamba limene muli kapena ali ndi masiku
- Dinani makiyi a Ctrl + 1 kuti mutsegule bokosi la bokosi la Mafomu
- Dinani pa Tsambali Namba mubox
- Dinani Tsikuli muwindo landandanda wa gulu (mbali ya kumanzere ya bokosi)
- Muwindo lawonekedwe (kumanja), dinani pa tsiku lomwe mukufuna
- Ngati maselo osankhidwa ali ndi deta, bokosi la Sample liwonetseratu chithunzi cha maonekedwe osankhidwa
- Dinani botani loyenera kuti musunge kusintha kwasinthidwe ndi kutseka bokosi
Kwa iwo amene amakonda kugwiritsa ntchito mbewa m'malo mwa keyboard, njira ina yothetsera bokosilo ndi:
- Dinani pakanema maselo osankhidwa kuti mutsegule mndandanda wamakono
- Sankhani Maofesi a Mafomu ... kuchokera mndandanda kuti mutsegule bokosi la bokosi la Mafomu
###########
Ngati, pambuyo pa kusintha kwa mtundu wamtundu wa selo, selo likuwonetsera mndandanda wa malemba a hayi, chifukwa selo silokwanira mokwanira kuti liwonetse deta yolinganiza. Kukulitsa selo kudzakonza vutoli.