Excel date and Time functions

Date and Time functions

Date returns the number of series at a specific time

DATEDIF calculates the number of years, months, and days between two dates

DATEVALUE converts a date in text format to a series number

Day converts series numbers to days in the month

DAYS360 calculates the number of days between two dates by 360 days a year

EDATE returns the number of series for a date specified before or after the start date

EOMONTH returns the number of series on the last day of a month before or after a specified number of months

HOUR converts a series number to an hour

MINUTE converts a series number to minutes

MONTH converts series numbers to months

Networkdays returns the full number of workdays between two dates

Now returns the number of series for the current date and time

SECOND converts a series number to seconds

Time returns the number of series for a specific period

TimeValue converts the time of the text format to the number of series

Today returns the number of series that date

Weekday converts a series number to a week

WORKDAY returns the number of series for a date before or after a specified number of workdays

Year converts series numbers to years

Yearfrac returns the number of years for the days between start_date (start date) and end_date (end date)

DDE and external functions

Call invokes a procedure in a dynamic-link library (DLL) or code source

REGISTER. ID returns the registered ID of the specified DLL or code source that was registered

Sql. REQUEST connects to the external data source, runs the query from the worksheet, and returns the result as an array without the need for macro programming.

Additional information about the call and register functions

Classification:

• Excel Tutorials