Eureka spreadsheet question.

From	Dave Symes <dave@triffid.co.uk>
Newsgroups	comp.sys.acorn.misc
Subject	Eureka spreadsheet question.
Date	2012-08-06 20:49 +0100
Organization	Triffids Leg Press
Message-ID	<52bb25d3c0dave@triffid.co.uk> (permalink)

Show all headers | View raw

SARPC RO 6.20 and Eureka Spreadsheet.
I've been messin' trying to get the spreadsheet to automatically do
something and can't get it to function how I want, so I'm hoping someone
here might have the solution.

It's to do with aged debts. (Customers who owe me lolly)

I want to enter a date in cell A10 of say 1/July/2012  (That's no problem,
entering dates or times and formatting them) what follows is the problem...

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.

Would appreciate the help.

Dave

-- 

Dave Triffid

Back to comp.sys.acorn.misc | Previous | Next — 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