Maqaalkan, waxaanu ku sharixi doonaa sida loo isticmaalo EDATE iyo hawlaha EOMONTH ee Microsoft Excel . Waxay asal ahaan yihiin, labadaba taariikhda iyo shaqada labadaba.

• EDATE waa shaqo ku jirta Excel oo soo celisa tirada taxanaha taariikhda, taasoo ah tirada la tilmaamay ee bilaha ka hor iyo ka dib taariikhda bilawga. Hawsha Edate waxa loo isticmaalaa in lagu xisaabiyo taariikhda qaan-gaadhka iyo taariikhda kama-dambaysta ah ee ku beegan isla taariikhda bisha ay tahay taariikhda la soo saaray. Qaabka shaqada Edate waa EDATE (bilawga_taariikhda, bilaha).
• Shaqada EOMONTH^(EOMONTH) waxay soo celisaa lambarka taxanaha maalinta ugu dambeysa ee bisha, taas oo ah, tirada bilaha ka hor ama ka dambeeya bilowga_taariikhda. Shaqada EOMONTH waxay xisaabisaa taariikhda qaan-gaadhka iyo taariikhda kama-dambaysta ah ee hoos u dhacda maalinta ugu dambeysa ee bisha. Qaabka shaqada EMONTH waa EMONTH (taariikhda bilowga, bilaha).

Isku dhafka EDATE iyo EOMONTH

EDATE

• Start_date : Taariikh muujinaysa tusaalaha taariikhda bilawga, 1/22/2021. Ha galin taariikhda bilawga qoraalka; dhibaato ayaa dhici doonta. Bilawga_date waa loo baahan yahay
• Bilaha^(Months) : Bishu waxay u taagan tahay tirada bilaha ka hor iyo ka dib Bilowga_Taariikhda^(Start_date) . Qiimaha togan ee bilaha waxa uu soo celiyaa taariikhda mustaqbalka, qiimihii tabanna waxa uu soo celiyaa taariikhda hore ee bilaha.

EOMONTH

• Start_date : Taariikh muujinaysa tusaalaha taariikhda bilawga, 1/22/2021. Ha galin taariikhda bilawga qoraalka; dhibaato ayaa dhici doonta. Bilawga_date waa loo baahan yahay
• Bilaha^(Months) : Bishu waxay u taagan tahay tirada bilaha ka hor iyo ka dib Bilowga_Taariikhda^(Start_date) . Qiimaha togan ee bilaha waxa uu soo celiyaa taariikhda mustaqbalka, qiimihii tabanna waxa uu soo celiyaa taariikhda hore ee bilaha.

Sida loo isticmaalo shaqada EDATE gudaha Excel

Casharradan, waxaan rabnaa inaan helno taariikhaha ka dib dhowr bilood ka dib, taariikhda kasta ka dib; tusaale ahaan, waxaan rabnaa inaan helno taariikhda shan bilood kadib Jan-20-20 .

Marka hore, dhagsii unugga meesha aad rabto inaad ku aragto natiijada, dabadeed ku qor =EDATE (A2, B2).

Riix Gelida^(Enter) , waxaad arki doontaa natiijadaada; Qiimaha taban ee shaxda (-2) wuxuu tagi doonaa laba bilood ka hor taariikhda shaxda.

Haddii natiijadu aanay ahayn taariikh balse ay tahay qiimayaal taxane ah, midig-guji unugga natiijada ee liiska hoos-u-dhaca dooro Qaabka Unugyada^{(Format Cells)(Format Cells)} .

Sanduuqa wada -hadalka ee Qaab^{(Format Cells)} -dhismeedka , dooro taariikh; dhanka midig, dooro nooca *3/14/2012 .

Guji OK^{(Click Ok)} waxay isu beddeli doontaa taariikh.

Dhig cursor meesha ugu hooseysa ee unugga. Waxaad arki doontaa calaamada Plus ; hoos u jiid. Natiijooyinka kale waxaad ku arki doontaa unugga kale.

Waxaa jira laba ikhtiyaar oo kale oo aad ku dhejin karto shaqada EDATE qolka.

Ikhtiyaarka koowaad waa inaad gujiso fx ; sanduuqa wada hadalka shaqada gelin ayaa soo bixi doona.

Insert Function sanduuqa wada hadalka, waxaad dooran kartaa qaybta shaqada aad rabto. Dooro qaybta Taariikhda iyo Waqtiga^{(Date and Time)} .

Xulo^(Select) liiska shaqada, dooro EDATE .

Sanduuqa wada hadalka doodda Function^{(Function Argument)} ayaa soo muuqan doona. Sanduuqa wada hadalka, meesha aad ku aragto Start_date nooca A2 ama guji unugyada A2 , waxay ka muuqan doontaa sanduuqa gelitaanka.

Bilaha ku qor ^{(Months )}B5 ama dhagsii unugga B5 , kaas oo si toos ah uga muuqda sanduuqa gelitaanka.

Hadda, guji OK waxaad arki doontaa natiijadaada.

Guji^(Click) cidhifka hoose oo jiid si aad u aragto natiijooyin kale.

Ikhtiyaarka Labaad waa in la aado Formulas -ka . Kooxda Function iyo Library^{(Function and Library)} , guji Taariikhda iyo Waqtiga^{(Date and Time)} ; Liiska hoos-u-dhaca dooro EDATE . Functions Sanduuqa wada hadalka doodaha ayaa soo bixi doona.^(Argument)

In sanduuqa wada hadalka doodaha Functions^{(Functions Argument)} , at Start_date , ku qor A2 ama dhagsii unugga A2 , kaas oo si toos ah uga muuqda sanduuqa gelitaanka.

Bilaha nooca B5 ama dhagsii unugga B5 , waxay si toos ah uga ^(B5)soo^(Months) muuqan doontaa sanduuqa gelitaanka.

Dooro OK ; waxaad arki doontaa natiijadaada.

Sida loo isticmaalo shaqada EOMONTH gudaha Excel

Casharradan, waxaan rabnaa inaan helno taariikhda ugu dambeysa ee bil kasta ka dib baaska miiska; tusaale ahaan, waxaan rabnaa inaan helno taariikhda ugu dambeysa ee 4 bilood ka dib taariikhda, Jan-17-20 .

Guji^(Click) unugga meesha aad rabto inaad natiijada dhigto. Nooca =EOMONTH ka dibna garabka.

Gudaha gunta, ku qor A2 , A5 , ka dibna xidh xidhka.

Riix Gelida^(Enter) , waxaad arki doontaa natiijadaada.

Guji^(Click) cidhifka hoose oo jiid si aad u aragto natiijooyinka kale.

Waxaa jira laba ikhtiyaar oo kale oo aad ku dhejin karto shaqada EOMONTH unugga.

Ikhtiyaarka koowaad waa inaad gujiso fx ; sanduuqa wada hadalka Gelida Function^{(Insert Function)} ayaa soo bixi doona.

Insert Function sanduuqa wada hadalka, waxaad dooran kartaa qaybta shaqada aad rabto. Dooro qaybta Taariikhda iyo Waqtiga^{(Date and Time)} .

Xulo^(Select) , liiska shaqada, dhagsii EOMONTH .

Sanduuqa wada hadalka doodaha Shaqada^{(Function Arguments)} ayaa soo bixi doona. Sanduuqa wada hadalka, meesha aad ku aragto Start_date nooca A2 ama guji unugyada A2 , waxay ka muuqan doontaa sanduuqa gelitaanka.

Bilaha nooca B5 ama dhagsii unugga B5 , waxay si toos ah uga ^(B5)soo^(Months) muuqan doontaa sanduuqa gelitaanka.

Hadda, guji OK waxaad arki doontaa natiijadaada.

Ikhtiyaarka Labaad waa in la aado qaacidooyinka. Kooxda Function iyo Library^{(Function and Library)} , guji Taariikhda iyo Waqtiga^{(Date and Time)} ; Liiska hoos-u-dhaca dooro EOMONTH . Functions Arguments sanduuqa wada hadalka ayaa soo bixi doona.

Sanduuqa wada hadalka doodaha Functions^{(Functions Argument)} , halkaas oo aad ku aragto Start_date nooca A2 ama guji unugyada A2 , waxay ka muuqan doontaa sanduuqa gelitaanka.

Bilaha nooca B5 ama dhagsii unugga B5 , waxay si toos ah uga soo muuqan doontaa sanduuqa gelitaanka.

Dooro OK ; waxaad arki doontaa natiijadaada.

Akhri soo socda: ^{(Read next:)} Sida loo isticmaalo Saacadda, Daqiiqada, iyo Shaqada Labaad ee Excel^{(How to use Hour, Minute, and Second Function in Excel)} .

How to use EDATE and EOMONTH Functions in Excel

In this article, we are going to explain how to use EDATE and the EOMONTH functions in Microsoft Excel. They are basiсally, both dаte and time functions.

• EDATE is a function in Excel that returns the serial number of the date, which is the indicated number of months before and after the start date. The Edate function is used to calculate the maturity date and due date that falls on the month’s same date as the issued date. The formula for the Edate function is EDATE (start_date, months).
• EOMONTH function returns the serial number of the last day of the month, that is, the number of months before or after the start_date. The EOMONTH function calculates the maturity date and due date that drops on the month’s last day. The formula for the EMONTH function is EMONTH (start_date, months).

Syntax of EDATE and EOMONTH

EDATE

• Start_date: A date that signifies the start date example, 1/22/2021. Do not enter the start date in the text; a problem will happen. The start_date is required.
• Months: Month represents the number of months before and after the Start_date. The months’ positive value returns a future date, and the negative value returns a past date for the months.

EOMONTH

• Start_date: A date that signifies the start date example, 1/22/2021. Do not enter the start date in the text; a problem will happen. The start_date is required.
• Months: Month represents the number of months before and after the Start_date. The months’ positive value returns a future date, and the negative value returns a past date for the months.

How to use EDATE function in Excel

In this tutorial, we want to find the dates after several months pass, after each date; for instance, we want to find the date five months after Jan-20-20.

First, click the cell where you want to see the result, then type =EDATE (A2, B2).

Press Enter, you will see your result; the negative value in the table (-2) will go to two months before the date in the table.

If the result not a date but serial values, right-click the cell of the result in the drop-down menu select Format Cells.

In the Format Cells dialog box, choose a date; on the right, choose type *3/14/2012.

Click Ok it will change into a date.

Place the cursor at the bottom end of the cell. You will see a Plus symbol; drag it down. You will see the other results in the other cell.

There are two other options that you can place the EDATE function into the cell.

Option number one is to click on fx; an insert function dialog box will appear.

In the Insert Function dialog box, you can select the category of function you want. Select the category Date and Time.

In the Select a function list, select EDATE.

A Function Argument dialog box will appear. In the dialog box, where you see Start_date type A2 or click the cell A2, it will appear in the entry box.

At Months type B5 or click the cell B5, which automatically appears in the entry box.

Now, click OK you will see your result.

Click on the bottom edge and drag to see other results.

Option Two is to go-to the Formulas. In the Function and Library group, click Date and Time; in its drop-down list select EDATE. Functions Argument dialog box will appear.

In the Functions Argument dialog box, at the Start_date, type A2 or click the cell A2, which automatically appears in the entry box.

At Months type B5 or click the cell B5, it will automatically appear in the entry box.

Select Ok; you will see your results.

How to use the EOMONTH function in Excel

In this tutorial, we want to find the last date after each month in the table pass; for instance, we want to find the last date of 4 months after the date, Jan-17-20.

Click the cell where you want to place the result. Type =EOMONTH then bracket.

Inside the bracket, type A2, A5, then close the bracket.

Press Enter, you will see your result.

Click on the bottom edge and drag to see the other results.

There are two more options that you can place the EOMONTH function into the cell.

Option number one is to click on fx; an Insert Function dialog box will appear.

In the Insert Function dialog box, you can select the category of function you want. Select the category Date and Time.

In the Select, a function list, click EOMONTH.

A Function Arguments dialog box will appear. In the dialog box, where you see Start_date type A2 or click the cell A2, it will appear in the entry box.

At Months type B5 or click the cell B5, it will automatically appear in the entry box.

Now, click OK you will see your result.

Option Two is to go-to the formulas. In the Function and Library group, click Date and Time; in its drop-down list select EOMONTH. Functions Arguments dialog box will appear.

In the Functions Argument dialog box, where you see Start_date type A2 or click the cell A2, it will appear in the entry box.

At Months type B5 or click the cell B5, it will automatically appear in the entry box.

Select OK; you will see your results.

Read next: How to use Hour, Minute, and Second Function in Excel.

Related posts

• Sida loo isticmaalo INT iyo Functions LCM gudaha Excel

• Sida loo geliyo oo loo xisaabiyo foomamka iyo shaqooyinka Excel

• Sida loo isticmaalo SUMIF iyo SUMIFS Functions gudaha Excel

• Sida loo isticmaalo MIN, Max, iyo AVERAGE Functions gudaha Excel

• Sida loo isticmaalo Beddelka iyo Bedelka Hawlaha gudaha Excel

• Sida loo isticmaalo shaqada DISC gudaha Excel

• Khaladka Run-time 1004, Ma socodsiin karo Macro gudaha Excel

• Sida loo isticmaalo Rept Function gudaha Excel

• Sida loo qaboojiyo oo loo kala qaybiyo xaashida shaqada ee Excel

• Sida loo dayactiro buug-shaqeedka Excel ee xumaaday

• Sida looga soo saaro magacyada domain URL-yada Microsoft Excel

• Casharka Microsoft Excel, ee Bilowga ah

• Sida loo isticmaalo shaqada COOSE ee Excel

• Sida loo isticmaalo sifada Nooca Xogta tooska ah ee Excel

• Xisaabi leexashada caadiga ah iyo khaladka caadiga ah ee macnaha Excel

• U beddelo CSV una beddelo Excel (XLS ama XLSX) adoo isticmaalaya khadka taliska ee Windows

• Sida loo isticmaalo shaqada ISODD ee Excel

• Microsoft Excel waxay isku dayaysaa inay soo ceshato macluumaadkaaga

• Sida loo abuuro Bracket tartanka gudaha Windows 11/10

• Sida loo isticmaalo shaqada NETWORKDAYS gudaha Excel