home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Media Share 9
/
MEDIASHARE_09.ISO
/
utility
/
pbaseiv.zip
/
P4SPR002.TIP
< prev
next >
Wrap
Text File
|
1991-12-16
|
2KB
|
56 lines
As a follow-up to "Easy Date-Entry Macro for 1-2-3" [January
1991 User Group Tips], I'd like to share a 1-2-3 date-entry
macro I've used for years. You don't have to type in a year
when you enter a date with this macro--it reads a default
year from another cell.
To create the macro, enter the labels in the listing below
into three columns, typing the four apostrophes where
indicated (they won't appear in the cells). With the pointer
on the cell containing \D, use the /Range Name Labels Right
command to name the macro.
Before using the macro, enter the default year (e.g., 1991)
in cell G1. Then, with the pointer on an appropriate cell,
press <Alt>-D, enter the desired month, press <Enter>, type
in the desired day, and press <Enter> again. For example,
assuming your default year is 1991, pressing
<Alt>-D6<Enter>16<Enter> would enter a date of June 16,
1991. To enter a year other than the default, press <Alt>-D,
backspace three characters, and type the new year and a
comma before entering the month number.
If you prefer to use the current year as your default,
replace the formula in cell B2 with @string(@year(@now),0),
and change the comment in C2 to "Fully automatic year
entry." You won't need to put a year in G1, and you can
still backspace to enter a different year number.
H. H. Michael Johl
Montreal, Quebec, Canada
Postscript: Also see the tip "Serious Dating" for another
way to use defaults for parts of dates.
The apostrophes (') won't appear onscreen when you enter
this Lotus 1-2-3 date-entry macro, which adds a default year
value to your dates. A ready-to-use copy of this worksheet
is available in the file P4SPREAD\AUTOYEAR.WK1 on your
PowerBase *.* Volume IV diskette.
A B C
1 '\D '@DATE( Date Macro
2 @STRING(G1-1900,0) Semi-automatic year entry
3 ',{?},{?})~ User enters month #, day #
4 '/RFD1~ Format date
Title: Getting the Year by Default
Category: SPR
Issue date: Jun 1991
Editor: Karl Koessel
Supplementary files: P4SPREAD\AUTOYEAR.WK1