[From nobody Mon Aug  2 21:28:56 2004
Return-Path: <bounce-usergroup-2914952@newsletter.oreilly.com>
X-Original-To: mlamertz@localhost
Delivered-To: mlamertz@localhost
Received: from localhost (tweety [127.0.0.1])
	by tweety.intern.perl-ronin.de (Postfix) with ESMTP id 52450C0010
	for <mlamertz@localhost>; Fri,  6 Feb 2004 22:34:57 +0100 (CET)
Received: from tweety.intern.perl-ronin.de ([127.0.0.1])
	by localhost (tweety [127.0.0.1]) (amavisd-new, port 10024) with LMTP
	id 30343-08 for <mlamertz@localhost>;
	Fri, 6 Feb 2004 22:34:56 +0100 (CET)
Received: from localhost (tweety [127.0.0.1])
	by tweety.intern.perl-ronin.de (Postfix) with ESMTP id EF0CEC0002
	for <mlamertz@localhost>; Fri,  6 Feb 2004 22:34:55 +0100 (CET)
Received: from struppi1.friedrichstrasse62.de [195.138.32.98]
	by localhost with POP3 (fetchmail-6.2.4)
	for mlamertz@localhost (single-drop);
	Fri, 06 Feb 2004 22:34:56 +0100 (CET)
Received: from mail.pm.org (mail.pm.org [64.49.222.22])
	by struppi1.friedrichstrasse62.de (8.9.3/8.9.3) with ESMTP id WAA01253
	for <mike@perl-ronin.de>; Fri, 6 Feb 2004 22:30:21 +0100
Received: from newsletter.oreillynet.com (newsletter.oreillynet.com
	[209.204.146.25])
	by mail.pm.org (8.11.6/8.11.6) with SMTP id i16LUL512760
	for <mlamertz@cologne.pm.org>; Fri, 6 Feb 2004 15:30:22 -0600
From: Marsee Henon <marsee@oreilly.com>
To: mlamertz@cologne.pm.org
Subject: Excel Annoyances Needed for New Book
Date: Fri, 06 Feb 2004 13:18:51 -0800
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit
List-Unsubscribe: <mailto:leave-usergroup-2914952W@newsletter.oreilly.com>
Message-Id: <LYRIS-2914952-16378-2004.02.06-13.18.52--mlamertz#cologne.pm.org@newsletter.oreilly.com>
X-UIDL: 7A?!!%o:"!Bb1"!*O<"!
X-Virus-Scanned: by amavisd-new-20030616-p7 (Debian) at tweety.dyndns.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=4.0
	tests=LINES_OF_YELLING
X-Spam-Level: 

Hey User Group Leader,

O'Reilly is pulling together a new book called "Excel Annoyances" and
we'd like your help! As you might guess from the title, this book aims
to identify the problems, snarls, quirks, bugs, and just dumb things
about Excel that drive users nuts. Oh yeah--it also aims to solve these
annoyances, too.

If any members of your group use Excel--be they newbies or Excel
masters--and they have annoyances they'd like to see solved, have them
email me (marsee@oreilly.com) with "Excel Annoyance" in the subject
line. Just have them note what version of Excel and Windows (or Mac
OS) they're using.

Thanks for sharing. We'll make sure to get copies of "Excel
Annoyances" sent to your group shortly after publication.


--Marsee


***
An example:

LET ME COUNT THE DAYS

THE ANNOYANCE: I know you can do date calculations in Excel, whether it's
to find how many days late I am on a car payment or to see how long it's
been since my last haircut. It's pretty easy to determine the number of
days between two dates; just subtract one from the other. But when I do
that, the result is another date! Huh?

THE FIX: In a blank worksheet, try this little exercise, which should
show your age in days:

1. In cell A1, enter your birth date in MM/DD/YYYY format.

2. In cell B1, enter the formula =today() to display the current date.

3. In cell C1, enter the formula =b1-a1.

You'll notice that the result of the formula in C1 is some other date,
which appears to have no correlation to either of the first dates. How
come? When you enter a formula, Excel matches the formatting of the
formula's inputs. This works well when you're doing calculations on
dollar amounts or percentages; the result comes out formatted just
the way you'd want. But in our example, Excel formatted the formula
result--a number of days--as a date.

***

]