Re: Eureka spreadsheet question.

From	Dave Wisnia at home <david@wisnia.net>
Newsgroups	comp.sys.acorn.misc
Subject	Re: Eureka spreadsheet question.
Date	2012-08-14 22:35 +0100
Organization	Home in Leeds
Message-ID	<26364ebf52.david@david.wisnia.net> (permalink)
References	<52bb25d3c0dave@triffid.co.uk> <52bb2c6f3bbrian@bdebenham.co.uk> <52bb5b9fc3dave@triffid.co.uk> <52bf3f2945dave@triffid.co.uk>

Show all headers | View raw

In message <52bf3f2945dave@triffid.co.uk>
          Dave Symes <dave@triffid.co.uk> wrote:

> In article <52bb5b9fc3dave@triffid.co.uk>,
>    Dave Symes <dave@triffid.co.uk> wrote:
>> In article <52bb2c6f3bbrian@bdebenham.co.uk>,
>>    Brian Debenham <brian@bdebenham.co.uk> wrote:
>>> 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

>> Thanks...
>> Ooer! That simple, no wonder I couldn't get it.

>> Small ointment fly though!

>> As I write this its 6:45 on the 7th August.

>> A1 has 1/7/2012
>> A10 has your formula but returns 37 days.
>> Including the 1st July to 7th Aug, today is the 38th day,

>> Adding a +1 to the formula sorts that...

>> Thanks
>> Dave

> My next question related to this matter is probably bordering on the
> silly, however, if I don't ask I'll never know.  ;-)

> Are there any methods in a sheet whereby when the debt becomes aged of n
> number of days, the answer in the cell or the cell/colour automatically
> changes.

> For example: When the age become 31 days, then the cell flashes or maybe
> changes colour to Red.

> Thanks
> Dave

Hello Dave

If the number 31 is in cell D5 for example, in the cell next to the 
answer (E5) put =if(D5>31,"OVERDUE!","").
Can't answer re background colour change - this will probably need a 
macro.

-- 
With very best wishes
Dave Wisnia

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