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


project dashboard in excelmicrosoft outlook questions and answersvba selection.deletehow to create xml file in excel 2007comboboxesexcel remove duplicate datadelete row excelhow to autofit columns in excelhow to create a vlookup in excel 2010excel vba graphadvanced excel vba traininghow to update hyperlinks in excelhow do you password protect an excel spreadsheetascending order and descending order worksheetcombination chart in excel 2007vba variable scopewhere to find developer tab in excel 2010combobox vba excelhow to find empty cell in excelchart title excel 2010vlookup sampleshow to create a vlookup formula in excel 2010pivot chart in excel 2010unhide rows in excel 2010how to delete a sheet in excelvba syntax checkerbuilding macros in excelexcel 2007 remove hyperlinkscreate new worksheet vbahow to remove empty rows in excelexcel formulas hlookup exampleexcel vba input boxexcel 2013 dashboard designcellcolorlistbox propertiesfrequently asked interview questions in sqlexcel filter out duplicateshow to unlock a sheet in excelexcel spreadsheet test for interviewapplication.filedialog msofiledialogfilepickerhow to check duplicate values in excelexcel.application.workbooks.openproject plan timeline excel templateif cell is blank excelloops excelunlock spreadsheetmicrosoft excel project schedule templateexcel userform databasemicrosoft access remove duplicateshow to create a new worksheet in excelloop for vbatimeline template in excelpivot table formulas excel 2010easy excel vbaproject milestone template excelwhat is a pivot table in excel used forhow to do pivot tables in excel 2010how to use hlookup formula in excelrange activecellvba select workbookmsg vbafunction vba returnhow to delete empty columns in excelhow to vlookup in excel 2007excel vba column rangerank vbaaverageifs excel 2010pivot table in sql server exampleschedule planner excelmacro delete rows based on cell valueexcel macro write to text filevba range offsetfso.createfolderplot chart excelmsgbox example vbaif statement in macro excelvba save excelvba code analyzerbubble chart excel 2013how do i do a pivot table in excel 2010delete file vbaexcel macro copy cellmicrosoft excel chart wizardtick box in excel 2010