• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VIII: Appendixes > Date and Time Functions

Date and Time Functions

Date and time functions manipulate or calculate dates and times. These functions generally work using date serial numbers. A date serial number is a number that represents a date and time in our calendar, but that is easier to work with for calculations. Table B.2 details the date and time functions available in Excel.

Table B.2. Date and Time Functions in Excel
Function SyntaxReturns
=DATE(year,month,day)Excel serial number of a specified date
=DATEVALUE(date_text)Excel serial number for a text-based date entry
DAY(serial_number)Day of the month (1-31) for an Excel date serial number
=DAYS360(start_date,end_date,method)Number of days between two dates using a 360-day calendar
=HOUR(serial_number)Hour (0-23) of an Excel serial number time value
=MINUTE(serial_number)Minute (0-59) of an Excel serial number time value
=MONTH(serial_number)Month (1-12) of an Excel serial number date value
=NOW( )Current date and time
=SECOND(serial_number)Second (0-59) of an Excel serial number time value
=TIME(hour,minute,second)Excel serial number fraction (from 0 to 0.99999999) for specified time
=TIMEVALUE(time_text)Excel serial number fraction for a text-based time entry
=TODAY( )Serial number date for today's date, using the date set in the computer's clock/calendar
=WEEKDAY(serial_number,return_type)Day of the week (1-7) based on a date serial number
=YEAR(serial_number)The year (from 1900 to 9999) an Excel date serial number represents



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint