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.