Re: Eureka spreadsheet question.

Path	csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!news.mixmin.net!news.musoftware.de!wum.musoftware.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail
From	Brian Debenham <brian@bdebenham.co.uk>
Newsgroups	comp.sys.acorn.misc
Subject	Re: Eureka spreadsheet question.
Date	Mon, 06 Aug 2012 22:01:37 +0100
Organization	Home
Lines	20
Message-ID	<52bb2c6f3bbrian@bdebenham.co.uk> (permalink)
References	<52bb25d3c0dave@triffid.co.uk>
X-Trace	individual.net AXDDEOn16DxSCUEY/l9NLwjAqJnEScFkCCCylg4YyH1cWflwhKOGbmTrVtsfUMqRE=
X-Orig-Path	bdebenham.co.uk!brian
Cancel-Lock	sha1:ktDGnbbZi8LYgrZNvz7URYxMI5w=
User-Agent	Pluto/1.14f (RISC-OS/3.71) NewsHound/v1.50-32
Xref	csiph.com comp.sys.acorn.misc:6029

Show key headers only | View raw

In article <52bb25d3c0dave@triffid.co.uk>,
   Dave Symes <dave@triffid.co.uk> wrote:
> In cell D10 I want some auto means of displaying the amount of time that
> has passed to now the 6th of August 2012 Obviously tomorrow when run it
> needs to display the new amount of time passed. (I am aware of the NOW()
> function but can't get it to do anything meaningfull).

> In other words when I run the sheet, I want that cell to tell me day by
> day, how many months or days have passed since the 1st of July.


All you need in D10 is =TODAY()-A10

Brian

-- 
Brian Debenham
brian@bdebenham.co.uk
StrongARMed and dangerous !
Chelmsford CAMRA: http://www.chelmsfordcamra.org.uk/

Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-06 20:49 +0100
  Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-06 21:53 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:48 +0100
      Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 09:02 +0100
      Re: Eureka spreadsheet question. M Harding <riscos@mdharding.org.uk> - 2012-08-07 11:22 +0100
        Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-07 12:33 +0100
        Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 20:04 +0100
  Re: Eureka spreadsheet question. Brian Debenham <brian@bdebenham.co.uk> - 2012-08-06 22:01 +0100
    Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-07 06:37 +0100
      Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-14 19:51 +0100
        Re: Eureka spreadsheet question. Dave Wisnia at home <david@wisnia.net> - 2012-08-14 22:35 +0100
          Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 07:11 +0100
            Re: Eureka spreadsheet question. Tony Moore <old_coaster@yahoo.co.uk> - 2012-08-15 10:42 +0000
              Re: Eureka spreadsheet question. Alan Calder <alan_calder@o2.co.uk> - 2012-08-15 13:34 +0100
              Re: Eureka spreadsheet question. John Bryan <john@bryan86.fsnet.co.uk> - 2012-08-15 14:30 +0100
                Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-15 21:43 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-18 19:06 +0100
                Re: Eureka spreadsheet question. Julian Fry <julainfry@tiscali.co.uk> - 2012-08-19 13:18 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:16 +0100
                Re: Eureka spreadsheet question. Dave Symes <dave@triffid.co.uk> - 2012-08-19 15:18 +0100

csiph-web