Excel Date & Time Functions:

Explained with Examples.

  • TIMEVALUE: TIMEVALUE is a Date and Time Function. This function converts a time represented by text to a serial number for a time.
  • DATEVALUE: DATEVALUE is a Date and Time Function. This function converts a date represented by text to a serial number for a date.
  • DAY: DAY is a Date and Time Function. This function returns the day of the month represented by a serial number.
  • MONTH: MONTH is a Date and Time Function. This function returns the month of a date.
  • YEAR: YEAR is a Date and Time Function. This function returns the year of a date.
  • SECOND: SECOND is a Date and Time Function. This function returns the second , a number from 0 to 59.
  • MINUTE: MINUTE is a Date and Time Function. This function returns the minute , a number from 0 to 59
  • HOUR: HOUR is a Date and Time Function. This function returns the hour as a number from 0 to 23
  • DAYS360: DAYS360 is a Date and Time Function. This function returns the number of days between two dates based on a 360 day year.
  • TIME: TIME is a Date and Time Function. This function returns the number that represents the particular time
  • DATE: DATE is a Date and Time Function. This functionreturns the number that represents the particular date.

Hey! Join Our Community

Get Quick Responses & Experts' Answers in Minutes!
Get Notified - When Answered Your Question!