execl公式与函数例题

======================================= Extended Date Functions Add-inFor Excel ======================================= Requires: Excel 97 or later version. Main file: xdate.xla Help file: xdate.hlp (Both of these files must be in the same directory.) Purpose: Enables Excel to work with dates prior to 1900. Installation: 1. Start Excel Excel 97 2. Select Tools - Add-Ins 3. Click the Browse button 4. Locate xdate.xla 5. Click OK to close the Add-Ins dialog box Usage: When the add-in is installed, your worksheet formulas can use the following new functions: XDATE, XDATEADD, XDATEDIF, XDATEYEARDIF, XDATEYEAR, XDATEMONTH, XDATEDAY, XDATEDOW. These functions are accessible from the Paste Function dialog box. The functions appear in the 'Date & Time' function category. To display the Paste Function dialog, click the Paste Function button, or use the Function command on the Insert menu). Select an XDATE function in the Paste Function dialog box and press F1 to view online help. Price: Free. The XDATE.XLA add-in file may be freely distributed, but it may not be sold, included with another product (including book/CD-ROM packages), or modified in any way. Developed by John Walkenbach, JWalk & Associates Copyright 1999, All Rights Reserved. Please report any problems or suggestions to: support@j-walk.com Web site: http://www.j-walk.com/ss/