Date & Time(Microsoft Excel Functions)

03/31/2024

Functions

Functions to manipulate date and time.

FunctionImportanceDescription
WORKDAY
WORKDAY.INTL
HighGet the date (serial value) after the specified number of business days.
EDATEHighGet a date (serial value) after the specified month, taking into account the last day of the month.

Function to get the date and time.

FunctionImportanceDescription
DATEHighGet date (serial value) by specifying year, month, and day.
TIMEHighGet time (serial value) by specifying hour, minute, and second.
TODAYHighGet the date(serial value) of the day.
NOWHighGet the current date and time (serial value).
EOMONTHHighGet the end-of-month date (serial value).
DATEVALUEHighConverts a string date to a serial value.
TIMEVALUEHighConverts a string time to a serial value.

Function to retrieve a portion of a date/time or attached information.

FunctionImportanceDescription
YEAR
MONTH
DAY
HOUR
MINUTE
SECOND
HighExtract the year, month, date, time, minute, and second.
WEEKDAYHighGet the day of the week corresponding to the date.
WEEKNUM
ISOWEEKNUM
MiddleGet how many weeks in the year the date is.
YEARFRACLowGet the percentage of the period between the two dates in a year.

Function to calculate the difference between multiple dates.

FunctionImportanceDescription
DAYSHighGet the number of days between two dates.
NETWORKDAYS
NETWORKDAYS.INTL
HighRetrieve the number of business days for the specified period.
DAYS360LowCalculate the number of days between two dates, using a year as 360 days (12 months x 30 days).