Advanced Excel Functions 简明教程

Advanced Excel - Date & Time Functions

Excel 日期和时间函数可用于从 Excel 日期和时间中提取信息，并在其上执行运算。

Excel Date and Time functions can be used to extract information from, and perform operations on, Excel Dates and Times.

一些 Excel 日期和时间函数是 Excel 2010 或 Excel 2013 的新函数，因此在早期版本的 Excel 中不可用。您可以在函数的适用性部分中找到此信息。

Some of the Excel Date & Time functions are new to Excel 2010 or Excel 2013, so are not available in earlier versions of Excel. You can find this information in the applicability section of the function.

Date and Time Functions

下表列出了所有日期和时间函数 −

The following table lists all the Date & Time functions −

S.No.	Function and Description
1	DATEReturns the serial number of a particular date.
2	DATEDIFCalculates the number of days, months, or years between two dates.
3	DATEVALUEConverts a date in the form of text to a serial number.
4	DAYConverts a serial number to a day of the month.
5	DAYSReturns the number of days between two dates.
6	DAYS360Calculates the number of days between two dates, based on a 360-day year.
7	EDATEReturns the serial number of the date that is the indicated number of months before or after the start date.
8	EOMONTHReturns the serial number of the last day of the month before or after a specified number of months.
9	HOURConverts a serial number to an hour.
10	ISOWEEKNUMReturns the number of the ISO week number of the year for a given date.
11	MINUTEConverts a serial number to a minute.
12	MONTHConverts a serial number to a month.
13	NETWORKDAYSReturns the number of whole workdays between two dates.
14	NETWORKDAYS.INTLReturns the number of whole workdays between two dates (international version).
15	NOWReturns the serial number of the current date and time.
16	SECONDConverts a serial number to a second.
17	TIMEReturns the serial number of a particular time.
18	TIMEVALUEConverts a time in the form of text to a serial number.
19	TODAYReturns the serial number of today’s date.
20	WEEKDAYConverts a serial number to a day of the week.
21	WEEKNUMReturns the week number in the year.
22	WORKDAYReturns the serial number of the date before or after a specified number of workdays.
23	WORKDAY.INTLReturns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.
24	YEARConverts a serial number to a year.
25	YEARFRACReturns the year fraction representing the number of whole days between start_date and end_date.