From mboxrd@z Thu Jan 1 00:00:00 1970 From: Josh Mattoon Subject: dates in a spreadsheet Date: Tue, 16 Mar 2010 22:04:30 -0800 Message-ID: <3a257d511003162304o7eea96b4u40c581bb3bd69521@mail.gmail.com> Mime-Version: 1.0 Content-Type: multipart/mixed; boundary="===============1983708486==" Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1NrmMt-0006b3-2L for emacs-orgmode@gnu.org; Wed, 17 Mar 2010 02:04:35 -0400 Received: from [140.186.70.92] (port=57006 helo=eggs.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1NrmMr-0006Zh-1I for emacs-orgmode@gnu.org; Wed, 17 Mar 2010 02:04:34 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.69) (envelope-from ) id 1NrmMp-0002z3-Ir for emacs-orgmode@gnu.org; Wed, 17 Mar 2010 02:04:32 -0400 Received: from mail-gy0-f169.google.com ([209.85.160.169]:47209) by eggs.gnu.org with esmtp (Exim 4.69) (envelope-from ) id 1NrmMp-0002yu-EI for emacs-orgmode@gnu.org; Wed, 17 Mar 2010 02:04:31 -0400 Received: by gyb13 with SMTP id 13so646118gyb.0 for ; Tue, 16 Mar 2010 23:04:30 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-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 --===============1983708486== Content-Type: multipart/alternative; boundary=001636988b1738605b0481f8e334 --001636988b1738605b0481f8e334 Content-Type: text/plain; charset=ISO-8859-1 I'm using the spreadsheet capabilities of org for the first time (very cool!) to plan an upcoming trip. I'd like to create a column formula to automatically calculate the dates/day of week but I'm a bit stumped. I don't see a way for the formula to know which row it is currently processing. I'm also coming up short trying to find any elisp to go from day of year -> formatted date string. Any suggestions? --001636988b1738605b0481f8e334 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable I'm using the spreadsheet ca= pabilities of org for the first time (very cool!) to plan an upcoming trip.= =A0I'd like to create a column formula to automatically calculate the = dates/day of week but I'm a bit stumped. =A0I don't see a way for t= he formula to know which row it is currently processing. =A0I'm also co= ming up short trying to find any elisp to go from day of year -> formatt= ed date string. =A0Any suggestions? --001636988b1738605b0481f8e334-- --===============1983708486== Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Disposition: inline _______________________________________________ Emacs-orgmode mailing list Please use `Reply All' to send replies to the list. Emacs-orgmode@gnu.org http://lists.gnu.org/mailman/listinfo/emacs-orgmode --===============1983708486==--