From mboxrd@z Thu Jan 1 00:00:00 1970 From: Salome Soedergran Subject: calculate weekday of birthday Date: Mon, 31 Jul 2017 15:10:36 +0200 Message-ID: <87379ciwfn.fsf@luna> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:39686) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1dcAU7-0005O9-L9 for emacs-orgmode@gnu.org; Mon, 31 Jul 2017 09:11:48 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1dcAU3-0004K8-7z for emacs-orgmode@gnu.org; Mon, 31 Jul 2017 09:11:47 -0400 Received: from vimdzmsp-sfwd03.bluewin.ch ([195.186.120.132]:39668 helo=smtpauths.lb.bluewin.ch) by eggs.gnu.org with esmtps (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.71) (envelope-from ) id 1dcAU3-0004HD-0R for emacs-orgmode@gnu.org; Mon, 31 Jul 2017 09:11:43 -0400 List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: "Emacs-orgmode" To: emacs-orgmode@gnu.org Hi everybody How can I make orgmode to give me the weekday of a specific date? I have a list (org-table) with students' names and dates of birth that looks like this: |------+-----------+------+-------+-----+-----+---------| | Name | Firstname | year | month | day | age | weekday | |------+-----------+------+-------+-----+-----+---------| | Doe | John | 2001 | 05 | 21 | 16 | | |------+-----------+------+-------+-----+-----+---------| #+TBLFM: @2$8..@>$6='(+ (- 2017 $5) (if(> $4 7) 0 1));L:: I have a formula to make orgtable calculate the age the student reaches in the current academic year (Aug-July) but I don't know how to get the birthday's weekday in the current year. Can anybody help me? Thanks a lot in advance! Best, Salome