|
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/08 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 (in InsDate.zip). 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.
- 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