Date & Time

Home/Excel Formulas/Date & Time

Excel Date & Time Functions:

Explained with Examples.

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


  • 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

Related pages


excel vba color rgblock hidden columns in excelexcel merging columnsvba if then else exampleexcel 2013 slicer tutorialexcel sheet protection passwordvba sub functionhow to detect duplicate in excelexcel ado connectionshortcut for hide in excelhow to create activex controlvba read fileexcel macro enabled workbookvba excel left functionsave excel file vbawriting functions in vbaauto fit row heighttechnical interview questions for freshers with answersexcel formula columnmerging cell in excelexcel add row shortcutmacro tutorial excelvba delete entire rowproject management dashboard template excelactivecell vbavba excel activeworkbookunlocking protected excel sheetsql interview questions for experienced pdfhow to hide numbers in excelvba saveas fileformatstring to int vbadeveloper ribbon excel 2007vba code to save excel filedelete blank cells in excelclustered cylinder chart excelvb arrayscolor formula in excel 2007open xml file in excel 2010ms powerpoint questions and answerscapacity planning excel template freeproject timetable template excelexcel macro delete columnmicrosoft office planner templateexcel password protect vbaexcel vba foreachvba selection.deletevlookup vba examplesimple cut and paste worksheetsexcel vba operatorstable pivot excelvlookup formula example excel 2007vb script interview questions and answers for freshersmultiple if statement in excelexcel advanced filter criteria range examplesexcel vba gotohow to append excel filesexcel macro rename worksheetvba sort ascendingdelete cells in excelinstr syntaxexcel vba hide columnexcel vba boxinterview questions for programmers and answersduplicate excel worksheetfileline accessexcel 2003 autosavehow to write an if statement in excelhow do you add developer tab to ribbonexcel macros how toexcel surface charthow to calculate difference between dates in excelsimple vba code examplescompare duplicates in exceldelete row in excel vbapowerpoint dashboard templatesexcel convert table to rangeexcel save macrounlock macrovba import data from another excel file