From mboxrd@z Thu Jan  1 00:00:00 1970
From: Ethan Ligon <ligon@are.berkeley.edu>
Subject: Date calculations in spreadsheet
Date: Sat, 04 Dec 2010 15:19:13 -0800
Message-ID: <87sjydxh1q.fsf@are.berkeley.edu>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=57162 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PP1O5-0008Nl-Qz
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 18:19:30 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PP1O4-0007er-Sl
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 18:19:29 -0500
Received: from lo.gmane.org ([80.91.229.12]:42085)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PP1O4-0007ea-NG
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 18:19:28 -0500
Received: from list by lo.gmane.org with local (Exim 4.69)
	(envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1PP1O2-0001hp-M2
	for emacs-orgmode@gnu.org; Sun, 05 Dec 2010 00:19:26 +0100
Received: from c-24-5-193-224.hsd1.ca.comcast.net ([24.5.193.224])
	by main.gmane.org with esmtp (Gmexim 0.1 (Debian))
	id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 05 Dec 2010 00:19:26 +0100
Received: from ligon by c-24-5-193-224.hsd1.ca.comcast.net with local (Gmexim
	0.1 (Debian)) id 1AlnuQ-0007hv-00
	for <emacs-orgmode@gnu.org>; Sun, 05 Dec 2010 00:19:26 +0100
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: emacs-orgmode@gnu.org

I'm working with a small spreadsheet, and would like to know how to
manage date calculations within the spreadsheet.  For example,

* How to do date calculations in a spreadsheet?
|------------------+--------------|
| Date             | Days elapsed |
|------------------+--------------|
| [2009-12-03 Thu] |              |
| [2010-12-03 Fri] |          365 |
| [2010-12-06 Mon] |            3 |
|------------------+--------------|

The question: What's the simplest way to construct a column formula for
the second column to deliver the indicated results?

And finally, my usual obligatory apology for not noticing the exhaustive
thread on exactly this topic that I've undoubtedly missed. 8^)

Thanks,
-Ethan