From mboxrd@z Thu Jan  1 00:00:00 1970
From: Michael Brand <michael.ch.brand@gmail.com>
Subject: Re: Date calculations in spreadsheet
Date: Sun, 5 Dec 2010 03:00:29 +0100
Message-ID: <AANLkTin76rGE+9mfu0eB6FDj_6p4bm8QvEbT3yX3C9+B@mail.gmail.com>
References: <ligon@are.berkeley.edu> <87sjydxh1q.fsf@are.berkeley.edu>
	<18596.1291510572@gamaville.dokosmarshall.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from [140.186.70.92] (port=43004 helo=eggs.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1PP3tx-0000sz-V5
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 21:00:35 -0500
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1PP3tu-00048M-WC
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 21:00:33 -0500
Received: from mail-iw0-f169.google.com ([209.85.214.169]:36783)
	by eggs.gnu.org with esmtp (Exim 4.71)
	(envelope-from <michael.ch.brand@gmail.com>) id 1PP3tu-000480-S9
	for emacs-orgmode@gnu.org; Sat, 04 Dec 2010 21:00:30 -0500
Received: by iwn33 with SMTP id 33so1426744iwn.0
	for <emacs-orgmode@gnu.org>; Sat, 04 Dec 2010 18:00:30 -0800 (PST)
In-Reply-To: <18596.1291510572@gamaville.dokosmarshall.org>
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: Ethan Ligon <ligon@are.berkeley.edu>
Cc: nicholas.dokos@hp.com, emacs-orgmode@gnu.org

On Sun, Dec 5, 2010 at 01:56, Nick Dokos <nicholas.dokos@hp.com> wrote:
> Ethan Ligon <ligon@are.berkeley.edu> wrote:
>> |------------------+--------------|
>> | Date =A0 =A0 =A0 =A0 =A0 =A0 | Days elapsed |
>> |------------------+--------------|
>> | [2009-12-03 Thu] | =A0 =A0 =A0 =A0 =A0 =A0 =A0|
>> | [2010-12-03 Fri] | =A0 =A0 =A0 =A0 =A0365 |
>> | [2010-12-06 Mon] | =A0 =A0 =A0 =A0 =A0 =A03 |
>> |------------------+--------------|
> |------------------+------------------+--------------|
> | Date =A0start =A0 =A0 =A0| Date end =A0 =A0 =A0 =A0 | Days elapsed |
> |------------------+------------------+--------------|
> | [2009-12-03 Thu] | [2010-12-03 Fri] | =A0 =A0 =A0 =A0 =A0365 |
> | [2010-12-03 Fri] | [2010-12-06 Mon] | =A0 =A0 =A0 =A0 =A0 =A03 |
> #+TBLFM: $3 =3D date(<$2>) - date(<$1>)

and then
|------------------+--------------|
| Date  start      | Days elapsed |
|------------------+--------------|
| [2009-12-03 Thu] |              |
| [2010-12-03 Fri] |          365 |
| [2010-12-06 Mon] |            3 |
#+TBLFM: $2 =3D date(<$1>) - date(<@-1$1>) :: @2$2 =3D string("")

Michael