Date & Time

Home/Excel Formulas/Date & Time

Excel Date & Time Functions:

Explained with Examples.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

BROWSE ALL TEMPLATES

50+ Project Management Templates Pack
Excel PowerPoint Word

VIEW DETAILS

Advanced Project Plan & Portfolio Template
Excel Template

VIEW DETAILS

Business Presentations Templates Pack
PowerPoint Slides

VIEW DETAILS

20+ Excel Project Management Pack
Excel Templates

VIEW DETAILS

20+ PowerPoint Project Management Pack
PowerPoint Templates

VIEW DETAILS

10+ MS Word Project Management Pack
Word Templates

VIEW DETAILS


  • 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.
LIMITED TIME OFFER