Excel Date and Time Functions List


Excel Date and Time Functions List

Creating Dates & Times
DATEReturns a date, from a user-supplied year, month and day
TIMEReturns a time, from a user-supplied hour, minute and second
DATEVALUEConverts a text string showing a date, to an integer that represents the date in Excel's date-time code
TIMEVALUEConverts a text string showing a time, to a decimal that represents the time in Excel
Current Date & Time
NOWReturns the current date & time
TODAYReturns today's date
Extracting The Components of a Time
HOURReturns the hour part of a user-supplied time
MINUTEReturns the minute part of a user-supplied time
SECONDReturns the seconds part of a user-supplied time
Extracting The Components of a Date
DAYReturns the day (of the month) from a user-supplied date
MONTHReturns the month from a user-supplied date
YEARReturns the year from a user-supplied date
WEEKNUMReturns an integer representing the week number (from 1 to 53) of the year from a user-supplied date
WEEKDAYReturns an integer representing the day of the week for a supplied date
Performing Calculations with Dates
EDATEReturns a date that is the specified number of months before or after an initial supplied start date
EOMONTHReturns a date that is the last day of the month which is a specified number of months before or after an initial supplied start date
WORKDAYReturns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date
WORKDAY.INTLReturns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date, using supplied parameters to specify weekend days (New in Excel 2010)
DAYS360Calculates the number of days between 2 dates, based on a 360-day year (12 x 30 months)
NETWORKDAYSReturns the number of whole networkdays (excluding weekends & holidays), between two supplied dates
NETWORKDAYS.INTLReturns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days (New in Excel 2010)
YEARFRACCalculates the fraction of the year represented by the number of whole days between two dates

Popular posts from this blog

Comments