[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Orgmode] Date calculations in spreadsheet
From: |
Michael Brand |
Subject: |
Re: [Orgmode] Date calculations in spreadsheet |
Date: |
Sun, 5 Dec 2010 03:00:29 +0100 |
On Sun, Dec 5, 2010 at 01:56, Nick Dokos <address@hidden> wrote:
> Ethan Ligon <address@hidden> wrote:
>> |------------------+--------------|
>> | Date | Days elapsed |
>> |------------------+--------------|
>> | [2009-12-03 Thu] | |
>> | [2010-12-03 Fri] | 365 |
>> | [2010-12-06 Mon] | 3 |
>> |------------------+--------------|
> |------------------+------------------+--------------|
> | Date start | Date end | Days elapsed |
> |------------------+------------------+--------------|
> | [2009-12-03 Thu] | [2010-12-03 Fri] | 365 |
> | [2010-12-03 Fri] | [2010-12-06 Mon] | 3 |
> #+TBLFM: $3 = 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 = date(<$1>) - date(<@-1$1>) :: @2$2 = string("")
Michael