document.write('<div class="feedburnerFeedBlock" id="microsoft/zWNv5hqb501eebfalm0qirfggg3brg">');
document.write('<p class="feedTitle">Date Time Functions</p>');
document.write('<ul>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214094" target="_blank" >How to use dates and times in Excel</a></span>');
document.write('<div>Describes how to use the built-in date and time functions in Excel to perform complex date and time calculations. Provides some examples.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/303216" target="_blank" >How to use dates and times in Excel for Mac</a></span>');
document.write('<div>... 06 represents the date and time 7\/8\/1992 1:26:24 A.M. To help you perform complex date and time calculations, Microsoft Excel includes many built-in date and time functions.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1293" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>How-to articles - Date\/Time. How to use dates and times in Excel for Mac Microsoft Excel ... Compares the functions in these versions with the functions in earlier versions of Excel.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb277364.aspx" target="_blank" >Implementing Week-Numbering Systems and Date\/Time Representations in ...</a></span>');
document.write('<div>Also learn why it is important to implement the date and time representation of the ... dates before 1900-01-01 in Excel, see MVP John Walkenbach\'s XDate: Extended Date Functions ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1293&aid=3&GSA_AC_More3" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Go To: Excel 2004 for Mac Functions Date\/Time Troubleshooting. Troubleshooting - Date\/Time. Date returned in a macro is four years too early</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/default.aspx/ph/2512?sid=202" target="_blank" >Excel 2003 Solution Center</a></span>');
document.write('<div>Functions. Date\/Time; Lookup Data; Statistical</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=202" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Functions. Date\/Time; Lookup Data; Statistical</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513?sid=1293&aid=2&GSA_AC_More2" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Go To: Excel 2004 for Mac Functions Date\/Time Download details. Download details - Date\/Time. MS08-074: Vulnerabilities in Office Excel could allow ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687841.aspx" target="_blank" >Known Issues in Excel XLL Development</a></span>');
document.write('<div>Because worksheet functions cannot activate worksheets within a workbook (only commands ... #include<boost\/date_time\/date_defs.hpp> #include <boost\/date_time\/time_defs.hpp></div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/320302" target="_blank" >XL2002: FRN: Solver.xla Is Missing the VBA Functions</a></span>');
document.write('<div>Solver.xla is missing Microsoft Visual Basic for Applications (VBA) functions in ... Date Time Version Size File name ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/aa730921.aspx" target="_blank" >Improving Performance in Excel 2007</a></span>');
document.write('<div>Example of period-to-date SUM formulas. Then copy the formula down to B2000. ... of Excel, but the manner in which you use them can often affect calculation time. Functions That ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687877.aspx" target="_blank" >Calling User-Defined Functions from DLLs</a></span>');
document.write('<div>Calling user-defined functions (UDFs) from a worksheet is as ... xPrice, 7, TempNum(39084.0), \/\/ settlement date 2 ... than if it has to look up the function name every time.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/324861" target="_blank" >How to find data in an Excel table</a></span>');
document.write('<div>This step-by-step article describes how to find data in a table (or range of cells) by using various built-in functions in Microsoft Excel. You can use different formulas to get ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/107564" target="_blank" >Not All Worksheet Functions Supported as Application</a></span>');
document.write('<div>Run-Time Error \'438\': Object doesn\'t support this property ... The worksheet functions that are available to Visual Basic ... Tan function TODAY() DATE ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/922441" target="_blank" >The Last Modified date and time value is automatically updated when ...</a></span>');
document.write('<div>In this scenario, the Last Modified date and time value of the file is automatically updated ... When you enable this policy, IRM functions in the same manner it does when the RMS ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214327" target="_blank" >XL2000: Wrong Date Returned When You Enter Month and Digits</a></span>');
document.write('<div>For example, \"Dec 32\" translates into December 1, 1932. NOTE: This same behavior applies when you enter text strings to represent dates into date and time worksheet functions.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/260893" target="_blank" >Works: Spreadsheet Functions Imported from Excel 2000 to Works</a></span>');
document.write('<div>Works: Spreadsheet Functions Imported from Excel 2000 to Works ... DATE DAY Returns correct day if ... Function changes to S. TAN TIME TRIM TRUE ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687915.aspx" target="_blank" >How to: Access DLLs in Excel</a></span>');
document.write('<div>The VBA Date type can represent dates as early as 1-Jan ... format for the regional settings in force at the time are ... As discussed earlier in the context of DLL functions, the ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/216578" target="_blank" >XL2000: Calculation Differences Between the Office Spreadsheet and ...</a></span>');
document.write('<div>NOTE: The functions MONTH and YEAR also return a date format instead of the respective values 12 and 99 in ... Microsoft Office Spreadsheet Component 9.0, run time</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/116117" target="_blank" >DateValue Function Doesn\'t Accept Date Literals</a></span>');
document.write('<div>However, \'date\' can also be any expression that can represent a date, a time, or both a ... and so on) or other functions that return the same type of information [the DATE ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/956836" target="_blank" >Description of the Excel 2007 hotfix package (Excel.msp, Xlconv.msp ...</a></span>');
document.write('<div>It takes several minutes to save .xlsb files that contain many VLOOKUP functions if ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/843504" target="_blank" >Description of the undiscovered tips about Excel</a></span>');
document.write('<div>This article describes some of the most powerful and useful features and functions ... Enter the current date or time If you want to quickly enter the current date in a cell ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214019" target="_blank" >Method to determine whether a year is a leap year</a></span>');
document.write('<div>The date system that is used by Excel is based on the Gregorian calendar, first ... Because the actual length of a sidereal year (the time required for the Earth to ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/213660" target="_blank" >Not all Excel worksheet functions are supported as methods of the ...</a></span>');
document.write('<div>Run-Time Error \'438\': Object doesn\'t support this property ... The worksheet functions that are available to Visual Basic ... Tan function TODAY() DATE ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/office/aa905419.aspx" target="_blank" >Excel 2007</a></span>');
document.write('<div>Implementing Week-Numbering Systems and Date\/Time Representations in Excel 2007 ... Excel New User Newsgroup; Excel Setup Newsgroup; Excel Worksheet Functions Newsgroup</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/124218" target="_blank" >Macro Examples Using XLODBC Functions</a></span>');
document.write('<div>Macro Examples Using XLODBC Functions ... the specified data source, you could receive the run-time ... ID, ORDER_AMT, \" &_ \"ORDER_DATE ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/958133" target="_blank" >Description of the Excel 2007 hotfix package (Excel.msp, Xlconv.msp ...</a></span>');
document.write('<div>... that contains Turkish dotted or dotless text, the functions do ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/2513" target="_blank" >Excel 2004 for Mac Solution Center</a></span>');
document.write('<div>Functions; Graphics; Headers and Footers; Import\/Export ... you may experience when you use these two different date ... version of Microsoft Excel, and the workbook contains time ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225774.aspx" target="_blank" >WorksheetFunction Object Members</a></span>');
document.write('<div>Used as a container for Microsoft Excel worksheet functions ... the beginning of the coupon period to the settlement date. ... Use EXPONDIST to model the time between events, such as ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/264626" target="_blank" >Description of Excel 2000 specifications</a></span>');
document.write('<div>... cells 200 in Solver Custom functions ... system is used) Latest date allowed December 31, 9999 for calculation Largest amount of time 9999:99:99 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/103839" target="_blank" >Regression Analysis and Best Fit Lines (XE0124)</a></span>');
document.write('<div>It also outlines some of the new statistical functions and ... virus-detection software that was available on the date ... through Friday, 6:00 A.M. to 6:00 P.M. Pacific time ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/321244" target="_blank" >XL2000: Drawings in Files That Are Created in Versions of Excel Before ...</a></span>');
document.write('<div>... undefined behavior no longer functions ... it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb687898.aspx" target="_blank" >xlAutoAdd</a></span>');
document.write('<div>... szBuf, L \"Thank you for adding Example.XLL\\n\" L \"build date %hs, time ... API Function Reference Add-in Manager and XLL Interface Functions xlAutoAdd</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/328933" target="_blank" >Numbers that are copied from Access 2002 paste as text in Excel 2002</a></span>');
document.write('<div>... but sorts as text and are not available for formulas and functions. ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb407625.aspx" target="_blank" >OLE DB for OLAP Properties Used by Excel 2007</a></span>');
document.write('<div>MDPROP_MDX_DRILL_FUNCTIONS: If the two lowest bits of this property are set, Excel ... type (DATA_TYPE) of the MEMBER_VALUE property of the key attribute of a Time dimension is Date ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/959641" target="_blank" >Description of the Excel 2007 hotfix package (Excel.msp, Xlconv.msp ...</a></span>');
document.write('<div>... use the Excel 2007 XLL Software Development Kit, you cannot use certain built-in functions ... Date Time Platform; Xlview.exe: 12.0.6334.5000: 12,872,560: 18-Nov-2008: 22:58: x86: Xlvprtid.xml</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb240927.aspx" target="_blank" >XlApplicationInternational Enumeration\u00A0[Excel 2007 Developer ...</a></span>');
document.write('<div>Order of date elements:0 = month-day-year1 = day-month ... True if you\u2019re not displaying functions in English. ... Time separator (:). xlUpperCaseColumnLetter: 7: Uppercase ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/833855" target="_blank" >Excel 2003 hotfix package: February 29, 2004</a></span>');
document.write('<div>... The FORECAST, STEYX, SLOPE and INTERCEPT functions cause different results ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/214249" target="_blank" >How to use the Conditional Sum Wizard in Microsoft Excel</a></span>');
document.write('<div>... Using the Conditional Sum Wizard does not increase the limit of seven nested IF functions in ... In the Column box, select Date; in the Is box, select >; in the This value box, type 10 ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/960401" target="_blank" >Description of the Microsoft Office 2008 for Mac 12.1.5 Update</a></span>');
document.write('<div>The SUMIFS and AVERAGEIFS functions may produce an incorrect ... Updated time zone information. This update provides updated ... that automatically keeps Microsoft software up-to-date.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/cc539928.aspx" target="_blank" >Building Excel 2007 and Excel Services Dashboards by Consuming Two ...</a></span>');
document.write('<div>The first time the user clicks this button, the add-in ... oppRange.get_Offset(0, 2).Value2 = \"Estimated Close Date\" ... Excel Services User-Defined Functions; Office Development with ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/327215" target="_blank" >Create a RealTimeData Server for Excel 2002 or later versions of Excel ...</a></span>');
document.write('<div>Release Date: October 21, 2002 For additional information about how to download ... method is called when an Excel file is opened that contains real-time data functions or ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/976476" target="_blank" >Description of the Excel 2007 hotfix package (Analys32-es-es.msp ...</a></span>');
document.write('<div>Visual Basic for Applications (VBA) functions for the Analysis ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/969682" target="_blank" >MS09-021: Description of the security update for Excel 2007: June 9 ...</a></span>');
document.write('<div>The issue occurs when you use scaling functions ... information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/ph/11346" target="_blank" >Excel 2007 Solution Center</a></span>');
document.write('<div>Use the INDEX and MATCH worksheet functions with multiple criteria Format an Excel ... list of data on a worksheet by using macros Use a macro to change the date\/time format ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/953823" target="_blank" >Information about how to work with Open XML Format files in Microsoft ...</a></span>');
document.write('<div>New functions in Excel 2008 are not preserved. These functions ... date group; top 10; font color; data bar-based; More than two ... multiple Open XML Format presentations at the same time in ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb177675.aspx" target="_blank" >International Property\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Date and Time ... xlNonEnglishFunctions: Boolean: True if you\u2019re not displaying functions in English.</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/887607" target="_blank" >Description of the Excel 2003 post-Service Pack 1 hotfix package ...</a></span>');
document.write('<div>This issue occurs when you use the GROWTH, TREND, LOGEST, or LINEST functions ... To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://support.microsoft.com/kb/114992" target="_blank" >SQLExecQuery and SQLRequest Limited to 255 Characters</a></span>');
document.write('<div>Note that this behavior does not occur every time you run ... when you use the SQLExecQuery or the SQLRequest functions with ... employee.FIRST_NAME, employee.HIRE_DATE, employee.HOME ...</div>');
document.write('</li>');
document.write('<li><span class="headline"><a href="http://msdn.microsoft.com/en-us/library/bb225807.aspx" target="_blank" >New Members and Constants\u00A0[Excel 2007 Developer Reference]</a></span>');
document.write('<div>Returns True if the CubeField is a date. Read-only Boolean. ... can have multiple filters applied to it at the same time. ... Bessel function, which is equivalent to the Bessel functions ...</div>');
document.write('</li>');
document.write('</ul>');
document.write(' <p class="fbsubscribelink"><a href="http://feeds.feedburner.com/microsoft/zWNv"><img border="0" src="http://www.feedburner.com/fb/i/icn/feed-icon-10x10.gif"/> Subscribe to this Feed</a></p>');
document.write(' <div id="creditfooter"><a href="http://www.feedburner.com" target="_blank"><img src="http://www.feedburner.com/fb/images/buzzboost-pwrd.gif" alt="Headlines by FeedBurner" style="border:0"/></a></div>');
document.write('</div>');