EXCEL FORMULAS - DATE AND TIME FUNCTIONS
DATE AND TIME FUNCTIONS
DATE AND TIME FUNCTIONS
There are a number of date functions available in Excel. Depending on your needs, you can use a date function in Excel to return the current date, the current time, or the day of the week. This article covers using the most commonly used date functions used in Excel: =TODAY() and =NOW()
Like all functions in Excel, entering date functions is very straightforward - just type in the function in the cell where you want the date or time to appear.
DATE AND TIME FUNCTIONS
FUNCTION | DESCRIPTION |
|---|---|
DATE
|
Returns the serial number of a particular date
|
DATEVALUE
|
Converts a date in the form of text to a serial number
|
DAY
|
Converts a serial number to a day of the month
|
DAYS360
|
Calculates the number of days between two dates based on a 360-day year
|
EDATE
|
Returns the serial number of the date that is the indicated number of months before or after the start date
|
EOMONTH
|
Returns the serial number of the last day of the month before or after a specified number of months
|
HOUR
|
Converts a serial number to an hour
|
MINUTE
|
Converts a serial number to a minute
|
MONTH
|
Converts a serial number to a month
|
NETWORKDAYS
|
Returns the number of whole workdays between two dates
|
NOW
|
Returns the serial number of the current date and time
|
SECOND
|
Converts a serial number to a second
|
TIME
|
Returns the serial number of a particular time
|
TIMEVALUE
|
Converts a time in the form of text to a serial number
|
TODAY
|
Returns the serial number of today's date
|
WEEKDAY
|
Converts a serial number to a day of the week
|
WEEKNUM
|
Converts a serial number to a number representing where the week falls numerically with a year
|
WORKDAY
|
Returns the serial number of the date before or after a specified number of workdays
|
YEAR
|
Converts a serial number to a year
|
YEARFRAC
|
Returns the year fraction representing the number of whole days between start_date and end_date
|
EXCEL FORMULAS - DATE AND TIME FUNCTIONS
