Date and Time Functions

Date and Time are stored as numbers in Excel. If you are new to this concept, Read the following article before going into Date and Time functions.

To analyze and perform calculations with date and time Excel has the following Date and Time functions.

TODAY	Returns today’s date
NOW	Returns the current date & time

DATE	Returns a date, from a user-supplied year, month and day
TIME	Returns a time, from a user-supplied hour, minute and second
DATEVALUE	Converts a text string showing a date, to an integer that represents the date in Excel’s date-time code
TIMEVALUE	Converts a text string showing a time, to a decimal that represents the time in Excel

DAY	Returns the day (of the month) from a user-supplied date
MONTH	Returns the month from a user-supplied date
YEAR	Returns the year from a user-supplied date
WEEKNUM	Returns an integer representing the week number (from 1 to 53) of the year from a user-supplied date
WEEKDAY	Returns an integer representing the day of the week for a supplied date
ISOWEEKNUM	Returns the ISO week number of the year for a given date

HOUR	Returns the hour part of a user-supplied time
MINUTE	Returns the minute part of a user-supplied time
SECOND	Returns the seconds part of a user-supplied time

EDATE	Returns a date that is the specified number of months before or after an initial supplied start date
EOMONTH	Returns 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
WORKDAY	Returns a date that is a supplied number of working days (excluding weekends & holidays) ahead of a given start date
WORKDAY.INTL	Returns 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
DAYS	Calculates the number of days between 2 dates
DAYS360	Calculates the number of days between 2 dates, based on a 360-day year
NETWORKDAYS	Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates
NETWORKDAYS.INTL	Returns the number of whole networkdays (excluding weekends & holidays), between two supplied dates, using parameters to specify weekend days
YEARFRAC	Calculates the fraction of the year represented by the number of whole days between two dates