Top Navigational Bar

Training Module: Date - Math In Tables
DocumentID: 613543
Revision Date: 29-Feb-96 1:35:46 PM

The information in this document applies to:
WordPerfect® 6.0 for DOS

Problem

Solutions: Date Math in Tables
WP 6.0 DOS and WPWin 6.0 now have the ability to compute x days, months, weeks or years into the past (only to 1900) or in the future (more or less unlimited). This is commonly known as the Julian Date. The Julian Date starts on January 1, 1900. January 1, 1900 is considered a 1, December 31, 1900 is 365, January 1, 1901 is the equivalent of 366 and so on. The date of 05/18/93 is 34106. This feature is useful for calculating numbers of days for loans, what day a payment is due, and how many days until Christmas! One way WP 6.0 allows us to make calculations with different dates is through the MDY command in Table Functions.

Create a table. Go to one cell and create a formula using the MDY function with today's date: MDY(5,18,93). When you enter back to your screen you will see a number like 34106. This is the number of days since January 1, 1900, the Julian Date. Go to another cell and type in your birthday using the MDY command. If you want to see how many days you have lived, subtract the two cells.

Hint: If you want to see the date written out instead of the Julian Date number, then change the Format of the cells to Date, (Table Edit, 1-Cell, 6-Number Type, 9-Date).

Application
Calculate the number of days until Christmas.

If you purchased a CD player today and had 90 days to pay it off, what would that date be?

Answer:

Details:


Product specifications, packaging, technical support and information (*Specifications*) refer to theUnited States retail English version only. Specifications for other versions may vary. All Specifications, claims, features, representations, and/or comparisons provided are correct to the best of our knowledge of the date of publication, but are subject to change without notice.OUR MAXIMUM AGGREGATE LIABILITY TO YOU AND THAT OF OUR DEALERS AND SUPPLIERS IS LIMITED. IT SHALL NOTEXCEED THE AMOUNT YOU PAID TO ACCESS THE INFORMATION. SEE LEGAL DISCLAIMER.