Date and Time Functions

Below listed are the various Date and Time functions of Microsoft Excel.

Date():

DATE function is used to form the date with the given day, month and year.

Datevalue():

The DATEVALUE function returns the respective serial number of the given date.

Day():

DAY function is used to pull the day of the month from the complete date.

Datedif():

DATEDIF function is used to calculate the number of years/months/days that have passed from the given date.

Days360():

DAYS360 function is used to calculate the number of days between 2 given dates in a 360 days/year.

Edate():

EDATE function is used to find the date after the specified number of months.

Eomonth():

EOMONTH function is used to find the last date of the month, from the given start date.

Hour():

HOUR function shows the hour of the day based on the given time or number.

Minute():

MINUTE function shows the minute of the day based on the given time or number.

Month():

MONTH function is used to pull the month of the year from the complete date given.

Networkdays():

NETWORKDAYS function calculates the number of working days between the two given dates.

Now():

NOW shows the current time and date.

Time():

TIME function returns the actual time from the given values.

Timevalue():

TIMEVALUE function returns the decimal value of the given time.