|
Need to calculate a new date
from today's date, or from some other date? Here a several methods. |
There are several ways to do
this, depending on what you want as output.
- You can use a WordPerfect table
to calculate the new date:
- Assuming the first date should
be in table cell A1:
- Format cell A1 as a Date by
right-clicking the cell, choosing Numeric Format, then Date/Time.
(You can click Custom to format the date differently, if desired.)
Click OK. In the table cell, enter a date such as 12/4/06 and
when you tab to the next cell or click in another cell, the date
will appear as a date-formatted string.
- Now, assuming you want to calculate
a date 90 days hence:
- In the second ("new date")
cell, format it as a Date, and then enter this formula in the
cell:
- Note that the table must be
set to auto-calculate. With the cursor in the table, click the
top menu: Table, Calculate. You should see the Calculate dialog,
which lets you turn automatic calculation on and off. Also, make
sure you have not turned calculation off in the cell itself (right-click
the cell, then choose Format, then un-check the "Ignore
cell when calculating" box).
- If you need to quickly calculate
or insert a date that is "x" days in the future
(or the past) from today, you can use this small macro. It asks
you for a date (the current date is the default), the number
of days (plus or minus) from today, and some basic format options.
Then it displays the new date in a small dialog, which lets you
insert the new date in the document at the current cursor location:
INSDATE.ZIP. (v1.01; 12/08/06;
6,351 bytes)
- To find the number of days between
two dates, see CHarles Rossiter's Julian
macro.
- To find the day of the week
a given date will fall on, try the Find
day of week macro.
- Roy "lemoto" Lewis
has posted several macros that calculate dates, such as Days
After and Due
Date..
|
Barry MacDonnell's