Follow Us on Facebook

វចនានុក្រមខ្មែរ​
Khmer Dictionaries

Follow us on Twitter

Google+

Search More Information

Friday, March 21, 2014

DATE Function in Excel 2010

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

0 comments :

Post a Comment

Like Me on Facebook

Donation by PayPal

Blog Archive

Loading...