The DATE function returns the sequential serial
number that represents a particular date.
|
FUNCTIONS
|
Description / Example
|
Results
|
|
DATE function
|
Returns the serial number of a particular
date
|
|
|
=DATE(year,month,day)
|
=DATE(1980,8,15)
|
8/15/1980
|
|
=DATE(YEAR(TODAY()),12,31)
|
Serial date for the last day of the
current year.
|
12/31/2013
|
|
=DATE(LEFT(A4,4),MID(A4,5,2), RIGHT(A4,2))
|
A formula that converts a date from the
YYYYMMDD format to a serial date. Ex: 20130515
|
5/15/2013
|
|
=DATEVALUE("mm/dd/yyyy")
|
Serial number of the text date, using the
1900 date system.
=DATEVALUE("07/12/2013") |
41467
|
|
=DATEVALUE("dd-mm-yyyy")
|
=DATEVALUE("12-Jul-2013")
|
41467
|
|
DAY Function
|
|
|
|
=DAY(serial_number)
|
12-Jul-2013
|
12
|
|
=DAYS360(start_date,end_date,[method])
|
Number of days in years
Star date: 11/1/2010 and end date: 8/2/2013 =DAYS360(DATE(2010,11,1),DATE(2013,8,2)) |
991
|
|
=
HOUR(serial_number)
|
The time that contains the hour you want
to find
|
11
|
|
=MINUTE(serial_number)
|
The time that contains the minute you want
to find.
|
7
|
|
=SECOND(serial_number)
|
The time that contains the seconds you
want to find.
|
59
|
|
=MONTH(serial_number)
|
The date of the month you are trying to
find.
|
12
|
|
=YEAR(serial_number)
|
The date of the year you want to find.
=YEAR(TODAY())-1980 |
33
|
|
=NOW()
|
Returns the serial number of the current
date and time
|
12/5/2013
11:07
|
|
TODAY function
|
|
|
|
=TODAY()
|
Returns the current date.
|
12/5/2013
|
|
=TODAY()+5
|
Returns the current date plus 5 days. For
example, if the current date is 7/10/2013, this formula returns 7/15/2013.
|
12/10/2013
|
|
=DATEVALUE("1/1/2030")-TODAY()
|
Returns the number of days between the
current date and 1/1/2030. Note that cell A4 must be formatted as General
or Number for the result to display correctly.
|
1/27/1916
|
|
=DAY(TODAY())
|
Returns the current day of the month (1 -
31).
|
5
|
|
=MONTH(TODAY())
|
Returns the current month of the year (1 -
12). For example, if the current month is June, this formula returns 7.
|
12
|
|
=WEEKDAY(serial_number,[return_type])
|
=WEEKDAY("7/10/2013",2)
|
3
|
