在本文中,我们将解释如何在Microsoft Excel中使用(Microsoft Excel)EDATE和EOMONTH函数。它们基本上是日期和时间函数。
- EDATE是Excel中的一个函数,它返回日期的序列号,即开始日期前后的指定月数。Edate函数(Edate)用于计算到期日和到期日,该日期与发行日同月。Edate函数的公式是EDATE (start_date,months)。
- EOMONTH函数返回该月最后一天的序号,即 start_date 之前或之后的月数。EOMONTH函数计算到期日和到期日,该日期在该月的最后一天下降。EMONTH函数的公式是EMONTH (start_date,months)。
EDATE 和 EOMONTH 的语法
教育日期
- Start_date:表示开始日期的日期,例如 2021 年 1 月 22 日。不要在文本中输入开始日期;会发生问题。start_date 是必需的。
- Months: Month 表示Start_date之前和之后的月数。月份的正值返回未来日期,负值返回月份的过去日期。
一个月
- Start_date:表示开始日期的日期,例如 2021 年 1 月 22 日。不要在文本中输入开始日期;会发生问题。start_date 是必需的。
- Months: Month 表示Start_date之前和之后的月数。月份的正值返回未来日期,负值返回月份的过去日期。
如何在 Excel 中使用 EDATE 函数
在本教程中,我们希望在每个日期之后找到几个月后的日期;例如,我们要查找Jan-20-20(Jan-20-20)五个月后的日期。
首先,单击要查看结果的单元格,然后键入=EDATE (A2, B2).
按Enter,你会看到你的结果;表中的负值 (-2) 将转到表中日期前两个月。
如果结果不是日期而是序列值,请右键单击下拉菜单中结果的单元格选择Format Cells。
在“单元格格(Format Cells)式”对话框中,选择一个日期;在右侧,选择类型*3/14/2012。
单击确定(Click Ok)它将更改为日期。
将光标放在单元格的底端。您将看到一个加(Plus)号;把它拖下来。您将在另一个单元格中看到其他结果。
还有两个选项可以将EDATE函数放入单元格中。
选项一是点击fx;将出现一个插入函数对话框。
在“插入函数( Insert Function)”对话框中,您可以选择所需的函数类别。选择类别日期和时间(Date and Time)。
在选择(Select)函数列表中,选择EDATE。
将出现一个函数参数(Function Argument)对话框。在对话框中,您会看到Start_date类型A2或单击单元格A2,它将出现在输入框中。
在Months中键入B5或单击单元格B5,它会自动出现在输入框中。
现在,单击确定(OK),您将看到结果。
单击(Click)底部边缘并拖动以查看其他结果。
选项二是转到公式(Formulas)。在函数和库(Function and Library)组中,单击日期和时间(Date and Time);在其下拉列表中选择EDATE。将出现函数参数(Argument)对话框。
在Functions Argument对话框的Start_date中,键入A2或单击单元格A2,该单元格会自动出现在输入框中。
在Months键入B5或单击单元格B5,它将自动出现在输入框中。
选择确定(Ok);你会看到你的结果。
如何在Excel中使用(Excel)EOMONTH函数
在本教程中,我们要在表中查找每个月之后的最后一个日期;例如,我们要查找日期之后 4 个月的最后一个日期Jan-17-20。
单击(Click)要放置结果的单元格。输入=EOMONTH,然后输入括号。
在括号内,键入A2、A5,然后关闭括号。
按Enter,您将看到结果。
单击(Click)底部边缘并拖动以查看其他结果。
还有两个选项可以将EOMONTH函数放入单元格中。
选项一是点击fx;将出现插入函数(Insert Function)对话框。
在“插入函数(Insert Function)”对话框中,您可以选择所需的函数类别。选择类别日期和时间(Date and Time)。
在Select函数列表中,单击EOMONTH。
将出现一个函数参数(Function Arguments)对话框。在对话框中,您会看到Start_date类型A2或单击单元格A2,它将出现在输入框中。
在Months键入B5或单击单元格B5,它将自动出现在输入框中。
现在,单击确定(OK),您将看到结果。
选项二是进入公式。在函数和库(Function and Library)组中,单击日期和时间(Date and Time);在其下拉列表中选择EOMONTH。将出现函数参数(Functions Arguments)对话框。
在Functions Argument对话框中,您会看到Start_date类型A2或单击单元格A2,它将出现在输入框中。
在 Months 键入B5或单击单元格B5,它将自动出现在输入框中。
选择确定(OK);你会看到你的结果。
阅读下一篇:(Read next:) 如何在 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 Εxcel. They are basically, both date and timе 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.