Use Msdn to search the Web.uuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=18412012-05-25T10:36:13Zuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1842

Article Returns the serial number of the current date. The serial number is the date-time code used by Microsoft Excel for date and time calculations.<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/Kc5NHTSvJ9A" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/CH006252823.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1843

Click one of the links in the following list to see detailed help about the function. Function Description DATE Returns the serial number of a particular date ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/PER9i9PxSKs" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/date-and-time-functions-reference-HP010079181.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1844

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 numbe ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/572cKKxvQZo" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/date-and-time-functions-HP005199659.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1845

Use Date and Time functions to create formulas that return serial numbers, display a specific date or time, or that calculate the difference between dates or times.<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/-uZAp5FvCWM" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/date-and-time-functions-reference-HP010342402.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1846

Date and time functions (reference) DATEVALUE function; DAY function; Display numbers as dates or times; EDATE function; MONTH function; View More<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/EEJTq_rna5Y" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/date-function-HP010062283.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1847

Date and time functions ... Returns the serial number of the current date and time: SECOND: Converts a serial number ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/LJceF-oAHKE" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP005204211.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1848

Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/Bcj8ZCGuP1w" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://support.microsoft.com/kb/214094uuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1849

Add-in and automation functions; Cube; Database and list management; Date and time; Engineering; Financial; Information; Logical; Lookup and reference; Math and trigonometry<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/J7BpF6wMLGQ" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/CH010064517.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1850

Time information in the date_text argument is ignored. Remarks. Excel stores dates as ... Date and time functions (reference) DATE function; Display numbers as dates or times<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/6TJrs9gMA14" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/datevalue-function-HP010062284.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1851

Time values are a portion of a date value and represented by ... Add or subtract units of time; Calculate the difference between two times; Convert times; Date and time functions ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/WMLJgNpY2w4" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/time-function-HP010062295.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1852

See Also. Date and Time functions; Insert Julian dates; NOW; TIMEVALUE; TODAY<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/ED712FGMcVE" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/datevalue-HP005209044.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1853

See Also. Add times; Date and Time functions; HOUR; MINUTE; NOW; SECOND<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/XkjE1HSi2H4" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/time-HP005209315.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1854

Use functions to simplify and shorten formulas on a worksheet, especially those ... Displays the value in C2 in a short date, 12-hour time format. Date-time: 8/6/2007 3:00 PM<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/oayKP8F3JHU" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/text-function-HP010062580.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1855

Count days before a date; Date and time functions (reference) DATE function; DAY function; Display numbers as dates or times; Insert Julian dates; Insert the current date and time ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/NqkuK6Q6LlA" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/today-function-HP010062297.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1856

Insert a date or time whose value is updated. To do this task, use the TODAY and NOW functions. Example. The example may be easier to understand if you copy it to a blank ...<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/V6NYpO6Z0MA" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/insert-the-current-date-and-time-in-a-cell-HP003056107.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1857

Date and time functions; Engineering functions; Financial functions; Information functions; Logical functions; Lookup and reference functions; Math and trigonometry functions<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/Zzyk9iTIPO4" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/excel-functions-by-category-HP010342656.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1858

Returns the serial number of the current date and time. If the cell format was ... Date and time functions (reference) DATE function; DAY function; View More<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/LvZQljY4bRk" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/now-function-HP010062293.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1859

This article describes the formula syntax and usage of the TIMEVALUE ... See Also. Date and time functions (reference)<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/_r7XKAFEqDs" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/timevalue-function-HP010342956.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1860

See Also. Buy Microsoft Office 2007 (Legacy) Date and Time functions; EDATE; EOMONTH; NETWORKDAYS; NOW<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/uqLOTGvtk60" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://office.microsoft.com/en-us/excel-help/workday-HP005209339.aspxuuid:c4e7d57c-b0a8-4f03-9efc-9463846d2fda;id=1861

Also learn why it is important to implement the date and time representation of the ... 2000, users are advised against using string arguments as inputs into date functions.<img src="http://feeds.feedburner.com/~r/microsoft/zWNv/~4/sRfyIgmgX5Y" height="1" width="1"/>

2012-05-25T10:36:13Zhttp://msdn.microsoft.com/en-us/library/bb277364(v=office.12).aspx