Gwiritsani Ntchito EOMONTH ya Excel kuwonjezera / kuchotsa miyezi mpaka masiku

01 ya 01

Lembani tsiku loyenera kapena tsiku loyamba ndi ntchito EOMONTH

EOMONTH ikugwira ntchito, yoperewera kwa Kutsiriza kwa mwezi kugwira ntchito, ikhoza kugwiritsidwa ntchito kuwerengetsera tsiku lokhwimitsa kapena tsiku lachiwongoladzanja kapena ntchito yomwe imagwa kumapeto kwa mweziwo.

Zowonjezereka, ntchitoyo imabweretsanso nambala yachitsulo pa tsiku lotsiriza la mwezi kwa nambala yomwe yasonyezedwa miyezi isanayambe kapena pambuyo pake.

Ntchitoyo ikufanana kwambiri ndi EDATE ntchito , kupatula kuti EDATE masiku obwereza omwe ali nambala yeniyeni ya miyezi isanayambe kapena pambuyo pa tsiku loyambira, pamene EOMONTH nthawizonse amawonjezera masiku okwanira kufika kumapeto kwa mweziwo.

Syntax ndi Ntchito Zogwira Ntchito

Mawu omasulira a ntchito amatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito , mabakiteriya, olekanitsa, ndi zifukwa .

Chidule cha ntchito ya EOMONTH ndi:

= EOMONTH (Start_date, Miyezi)

Yambani_date - (yofunikira) tsiku loyamba la polojekiti kapena nthawi yomwe ikufunsidwa

• Mtsutso uwu ukhoza kukhala tsiku lolowera kuntchito, kapena dzina lotchulidwa kapena selo lotanthauzira malo a deta mu tsamba la ntchito.
• ngati zolembedwera za selo pa tsiku loyambira zimayang'ana selo yopanda kanthu, ntchitoyo imatenga selo kukhala ndi nambala yeniyeni ya nambala ndikuwerengera tsiku lomaliza kukhala miyezi yambiri pambuyo pa tsiku lopanda pake January 0, 1900 - monga momwe zasonyezedwera mzere 9 wa chitsanzo.

Miyezi - (yofunika) chiwerengero cha miyezi isanayambe kapena pambuyo pake

• Mtsutso uwu ukhoza kukhala tsiku lolowetsedwa mu ntchitoyo kapena dzina lake lotanthauzira kapena selo lotanthauzira za malo a deta mu tsamba la ntchito;
• Miyezo yabwino imapereka masiku amtsogolo - mzere 8 mu chithunzi pamwambapa;
• Zosasokoneza zaka zam'mbuyomu - mzere 3 mu chithunzi pamwambapa;

• Ngati miyezi siyinji yeniyeni, iyo imayendetsedwa (gawo la decimal limachotsedwa) - monga momwe tawonedwera mzere 8 mu fano pamwamba pomwe zaka 12.25 zimadulidwa ku integer 12;

Zovuta Zobwereza Zamtengo

Ntchito imabwerera #VALUE! zolakwika ngati:

• Yambani_date si tsiku lovomerezeka - monga momwe tawonetsera mu mzere 4 mu chithunzi pamwambapa, kuyambira 2/30/2016 (February 30, 2016) ndi tsiku losavomerezeka;
• Mafotokozedwe a maselo amagwiritsidwa ntchito pa kutsutsana kwa mwezi kumalo omwe ali ndi ma Boolean , data data, kapena mfundo zolakwika .

Ntchito imabweretsanso #NUM! zolakwika ngati:

• Yambani_date isanafike pa January 1, 1900;
• Kuyambira_kumapeto kwa miyezi kumapereka tsiku lisanayambe pa January 1, 1900.

Excel EOMONTH Ntchito Chitsanzo

Mu chithunzi pamwambapa, EOMONTH ikugwira ntchito kuwonjezera ndikuchotsa miyezi ingapo mpaka tsiku la January 1, 2016.

Zomwe zili pansipa zikukhudza njira zomwe zingagwiritsidwe ntchito kulowa mu selo B3 la tsamba

Kulowa ntchito ya EOMONTH

Zosankha zogwira ntchito ndi zifukwa zake zikuphatikizapo:

• Kujambula ntchito yonse: = EOMONTH (A3, C2) mu selo C3;
• Kusankha ntchito ndi zifukwa zake pogwiritsa ntchito EOMONTH ntchito yolemba 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 amalowa mu EOMONTH ntchito yomwe ikuwonetsedwa mu selo B3 mu chithunzi pamwamba pogwiritsa ntchito bokosi la bokosi.

Popeza kuti phindu loti lilembedwe pa ndondomeko ya miyezi ndiloipa (-6) tsikulo m'ma cell B3 adzakhala kale kuposa tsiku loyamba.

EOMONTH Chitsanzo - Miyezi Yotsitsa

1. Dinani pa selo B3 - kuti mupange selo yogwira ntchito;
2. Dinani pa Fomu tab ya riboni;
3. Dinani pa Tsiku ndi Nthawi ntchito kuti mutsegule ntchito yolemba pansi mndandanda;
4. Dinani EOMONTH mundandanda wolezera bokosi lazokambirana ;
5. Dinani pa Start_date mzere mu bokosi la dialog;
6. Dinani pa selo A3 mu tsambalo kuti mulowetse selololo mu bokosi la dialogso monga mtsutso wa Start_date ;
7. Dinani pa Mwezi mzere mu bokosi la dialog;
8. Dinani pa selo B2 patsiku la ntchito kuti mulowetse selolo mu bokosi la dialogso monga mtsutso wa Miyezi ;
9. Dinani OK kuti mutseke bokosi la bokosi ndikubweranso ku tsamba la ntchito;
10. Tsiku la 7/31/2015 (July 31, 2016) - likupezeka mu selo B3 yomwe ili tsiku lomaliza la mwezi umene uli miyezi isanu ndi umodzi isanafike tsiku loyamba;
11. Ngati chiwerengero, monga 42216, chikuwonekera mu selo B3, ndiye kuti selo liri ndi maonekedwe ambiri. Onani malangizo apafupi kuti musinthe selo kuti muyambe kupanga maonekedwe;
12. Ngati inu mutsegula pa selo B3 ntchito yonse = EOMONTH (A3, C2) ikuwoneka mu bar barula pamwamba pa tsamba.

Kusintha mtundu wa Date mu Excel

Njira yosavuta yosavuta yosinthira fomu yamakono ya maselo omwe ali ndi EOMONTH ntchito ndi kusankha imodzi kuchokera mndandanda wazomwe mungakonzere kupanga maonekedwe mu bokosi la dialogs.

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:

1. Onetsetsani maselo omwe ali mu tsamba limene muli kapena ali ndi masiku;
2. Dinani makiyi a Ctrl + 1 kuti mutsegule bokosi la bokosi la Format ;
3. Dinani pa Tsamba la Nambala mu bokosi la dialog;
4. Dinani Tsikuli m'ndandanda wamndandanda wa gulu (tsamba lamanzere la bokosi la dialog);
5. Muwindo la mtundu (kumanja), dinani pa tsiku lofunidwa;
6. Ngati maselo osankhidwa ali ndi deta, bokosi la Sample liwonetseratu chithunzi cha mawonekedwe osankhidwa;
7. 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:

1. Dinani pakanema maselo osankhidwa kuti mutsegule zolemba zamkati;
2. 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.