Below listed are the various Date and Time functions of Microsoft Excel.
DATE function is used to form the date with the given day, month and year.
The DATEVALUE function returns the respective serial number of the given date.
DAY function is used to pull the day of the month from the complete date.
DATEDIF function is used to calculate the number of years/months/days that have passed from the given date.
DAYS360 function is used to calculate the number of days between 2 given dates in a 360 days/year.
EDATE function is used to find the date after the specified number of months.
EOMONTH function is used to find the last date of the month, from the given start date.
HOUR function shows the hour of the day based on the given time or number.
MINUTE function shows the minute of the day based on the given time or number.
MONTH function is used to pull the month of the year from the complete date given.
NETWORKDAYS function calculates the number of working days between the two given dates.
NOW shows the current time and date.
TIME function returns the actual time from the given values.
TIMEVALUE function returns the decimal value of the given time.