Many users are surprised to discover that Excel cannot work with dates prior to the year 1900. The Extended Date Functions add-in (XDate) corrects this deficiency, and allows you to work with dates in the years 0100 through 9999.
When the XDate add-in is installed, you can use any of the following new worksheet functions in your formulas:
NEW - Thanks to
J.E. McGimpsey, a Macintosh version
The XDate add-in is particularly useful for genealogists and others who need to perform simple calculations using pre-1900 dates. The figure below, for example, shows the XDATEYEARDIF function being used to calculate ages.
The XDate add-in requires Excel 97 or later. A version for Excel/Macintosh is also available.
Be careful if you use dates prior to 1752. Differences between the historical American, British, Gregorian, and Julian calendars can result in inaccurate computations.
PUP v5 also includes the XDATE functions. However, they are not packaged in an add-in. Rather, you can add the functions directly to the VBA project for your workbook. As a result, you can distribute the workbook without a dependent add-in.
This add-in is fully functional, not crippled, and has no nag messages. It's absolutely free, with no strings attached. Click the link below to go to the download page.
Complete context-sensitive online help is included (Windows version only).
Excel For Windows Installation:
Installation is a two-step process:
You can type the functions manually, or use Excel's Paste Function dialog box. To access the Paste Function dialog, click the Paste Function button, or select Insert - Function. The XDate Functions are listed in the 'Date & Time' Category. When a function is selected in the Paste Function dialog, press F1 to read the online help.
Excel for Macintosh Installation
Installation is a three-step process:
To report a problem with the XDate add-in for Windows, contact J-Walk & Associates via email.