Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.sys.acorn.misc > #6027 > unrolled thread

Eureka spreadsheet question.

Back to article view | Back to comp.sys.acorn.misc

Contents

  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

#6027 — Eureka spreadsheet question.

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

[toc] | [next] | [standalone]

#6028

Hello Dave,

=days360("01/07/2012",now())

Should do it.

Best wishes

Dave Wisnia


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

> 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



-- 
With very best wishes
Dave Wisnia

[toc] | [prev] | [next] | [standalone]

#6032

In article <f6a92bbb52.david@david.wisnia.net>,
   Dave Wisnia at home <david@wisnia.net> wrote:
> Hello Dave,

> =days360("01/07/2012",now())

> Should do it.

> Best wishes

> Dave Wisnia

[Snippy]

Thanks for the above, one small snag, it's always two days out.

EG:

It is now 6:45 on Tuesday 7th August.

Using the above:

A1 has 1/7/2012
A10 has your formula, the answer returned is 36 days.

Unless my calendar is wrong, from and including the 1st July to now 7th
August is 38 days.

Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6033

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

> In article <f6a92bbb52.david@david.wisnia.net>,
>    Dave Wisnia at home <david@wisnia.net> wrote:
>> Hello Dave,

>> =days360("01/07/2012",now())

>> Should do it.

>> Best wishes

>> Dave Wisnia

> [Snippy]

> Thanks for the above, one small snag, it's always two days out.

> EG:

> It is now 6:45 on Tuesday 7th August.

> Using the above:

> A1 has 1/7/2012
> A10 has your formula, the answer returned is 36 days.

> Unless my calendar is wrong, from and including the 1st July to now 7th
> August is 38 days.

> Dave

You're right! Even adding +2 to the formula doesn't work (it's a 
further 2 days out calculating from 1st January).

Apologies.


-- 
With very best wishes
Dave Wisnia

[toc] | [prev] | [next] | [standalone]

#6034

In article <52bb5ca19bdave@triffid.co.uk>,
   Dave Symes <dave@triffid.co.uk> wrote:
> In article <f6a92bbb52.david@david.wisnia.net>,
>    Dave Wisnia at home <david@wisnia.net> wrote:

> > =days360("01/07/2012",now())

> > Should do it.

> > Best wishes

> > Dave Wisnia

> [Snippy]

> Thanks for the above, one small snag, it's always two days out.

> EG:

> It is now 6:45 on Tuesday 7th August.

> Using the above:

> A1 has 1/7/2012
> A10 has your formula, the answer returned is 36 days.

> Unless my calendar is wrong, from and including the 1st July to now
> 7th August is 38 days.

I was curious to try this out in the (now-free) PipeDream 4.5.
In B2 I put in the date 1.7.12 and it duly displayed as 1 JUL 2012.

I then put in TODAY-B2  but it returned 37.

Days elapsed since that date, rather than inclusive - but different
from Eureka.

Michael Harding
Rev. Preb. M.D. Harding   riscos@mdharding.org.uk

[toc] | [prev] | [next] | [standalone]

#6035

In message <52bb75bba1riscos@mdharding.org.uk>
          M Harding <riscos@mdharding.org.uk> wrote:

> In article <52bb5ca19bdave@triffid.co.uk>,
>    Dave Symes <dave@triffid.co.uk> wrote:
>> In article <f6a92bbb52.david@david.wisnia.net>,
>>    Dave Wisnia at home <david@wisnia.net> wrote:

>>> =days360("01/07/2012",now())

>>> Should do it.

>>> Best wishes

>>> Dave Wisnia

>> [Snippy]

>> Thanks for the above, one small snag, it's always two days out.

>> EG:

>> It is now 6:45 on Tuesday 7th August.

>> Using the above:

>> A1 has 1/7/2012
>> A10 has your formula, the answer returned is 36 days.

>> Unless my calendar is wrong, from and including the 1st July to now
>> 7th August is 38 days.

> I was curious to try this out in the (now-free) PipeDream 4.5.
> In B2 I put in the date 1.7.12 and it duly displayed as 1 JUL 2012.

> I then put in TODAY-B2  but it returned 37.

> Days elapsed since that date, rather than inclusive - but different
> from Eureka.

> Michael Harding
> Rev. Preb. M.D. Harding   riscos@mdharding.org.uk

It is the same as Excel's undocumented "datedif" function.

Incidentally the days360 function works as 12 months with 30 days in 
each, hence the seeming maths error.


-- 
With very best wishes
Dave Wisnia

[toc] | [prev] | [next] | [standalone]

#6036

In article <52bb75bba1riscos@mdharding.org.uk>,
   M Harding <riscos@mdharding.org.uk> wrote:

> I was curious to try this out in the (now-free) PipeDream 4.5.
> In B2 I put in the date 1.7.12 and it duly displayed as 1 JUL 2012.

> I then put in TODAY-B2  but it returned 37.

> Days elapsed since that date, rather than inclusive - but different
> from Eureka.

Don't have Pipe thing, but in Fireworkz32

If you do as I suggested in my second post Michael and put the +1 on
the end of the function.

TODAY-B2+1

It'll be correct.

Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6029

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/

[toc] | [prev] | [next] | [standalone]

#6031

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


-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6076

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

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6083

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

[toc] | [prev] | [next] | [standalone]

#6084

In article <26364ebf52.david@david.wisnia.net>,
   Dave Wisnia at home <david@wisnia.net> wrote:
> In message <52bf3f2945dave@triffid.co.uk>
>           Dave Symes <dave@triffid.co.uk> wrote:

>

[Snippy]

> > 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.

Thanks for the thought...
But.
I already have an array formula in the form of...

{=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6091

On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
> In article <26364ebf52.david@david.wisnia.net>,
>    Dave Wisnia at home <david@wisnia.net> wrote:
> > In message <52bf3f2945dave@triffid.co.uk>
> >           Dave Symes <dave@triffid.co.uk> wrote:

[snip]

> > > 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.
>
> > 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.
>
> Thanks for the thought... But. I already have an array formula in the
> form of...
>
> {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

I know nothing about Eureka, but PipeDream allows a negative velue to be
displayed in red. This could be applied to a cell showing '30 - age'.

Tony

[toc] | [prev] | [next] | [standalone]

#6095

In article <fa4196bf52.old_coaster@old_coaster.yahoo.co.uk>,
   Tony Moore <old_coaster@yahoo.co.uk> wrote:
> On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
> > In article <26364ebf52.david@david.wisnia.net>,
> >    Dave Wisnia at home <david@wisnia.net> wrote:
> > > In message <52bf3f2945dave@triffid.co.uk>
> > >           Dave Symes <dave@triffid.co.uk> wrote:

> [snip]

> > > > 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.
> >
> > > 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.
> >
> > Thanks for the thought... But. I already have an array formula in the
> > form of...
> >
> > {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

> I know nothing about Eureka, but PipeDream allows a negative velue to be
> displayed in red. This could be applied to a cell showing '30 - age'.

Eureka has a Number Format option that allows negative numbers to be shown
in red.  Set up to do this as £s but easily edited.  Could this formatting
option get what DS is wanting?

Alan

[Snip]

-- 
Alan Calder, Milton Keynes, UK.

[toc] | [prev] | [next] | [standalone]

#6097

In message <fa4196bf52.old_coaster@old_coaster.yahoo.co.uk>
          Tony Moore <old_coaster@yahoo.co.uk> wrote:

> On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
>> In article <26364ebf52.david@david.wisnia.net>,
>>    Dave Wisnia at home <david@wisnia.net> wrote:
>>> In message <52bf3f2945dave@triffid.co.uk>
>>>           Dave Symes <dave@triffid.co.uk> wrote:

> [snip]

>>>> 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.
>>
>>> 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.
>>
>> Thanks for the thought... But. I already have an array formula in the
>> form of...
>>
>> {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

> I know nothing about Eureka, but PipeDream allows a negative velue to be
> displayed in red. This could be applied to a cell showing '30 - age'.

> Tony

Eureka's IF function is 
=IF(logical_test,result_if_true,result_if_false)
Your line above can be simplified to:
 =If(D11>=31,"Debtor","Okay") or even simpler IF(D11>=31,"Debtor",0)

The second one would require the Options-Window-display zero option 
clear and the Debtor would only appear when over 31 days. You could 
set the cell font colour to red for more effect.

When in Okay condition nothing shows but when in Debtor condition the 
word Debtor would be in red.

Going on from Tony's reply Eureka allows negative numbers to displayed 
in {Red} or [Green} or [Blue} etc using the Format-Number option:
    #,###0.00:{Red}#,###.00    OR  #,###0.00:{Green}#,###.00 etc

You could use a formula in D11 such as:
=If(Today()-B11>=31,C11*-1,C11)

This would display the cell contents black when less than 31 days
and red when over 31 days the cell contents have been made negative so 
that the amount would subtract from any calculation carried out using 
this cell.

Hope this is of some help

-- 
John Bryan

[toc] | [prev] | [next] | [standalone]

#6107

In article <9baca5bf52.JohnyBoy@john.bryan86.fsnet.co.uk>,
   John Bryan <john@bryan86.fsnet.co.uk> wrote:

> > On 15 Aug 2012, Dave Symes <dave@triffid.co.uk> wrote:
> >> In article <26364ebf52.david@david.wisnia.net>,
> >>    Dave Wisnia at home <david@wisnia.net> wrote:
> >>> In message <52bf3f2945dave@triffid.co.uk>
> >>>           Dave Symes <dave@triffid.co.uk> wrote:

> > [snip]

> >>>> 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.
> >>
> >>> 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.
> >>
> >> Thanks for the thought... But. I already have an array formula in the
> >> form of...
> >>
> >> {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

[Snippy]

> Eureka's IF function is 
> =IF(logical_test,result_if_true,result_if_false)
> Your line above can be simplified to:
>  =If(D11>=31,"Debtor","Okay") or even simpler IF(D11>=31,"Debtor",0)

> The second one would require the Options-Window-display zero option 
> clear and the Debtor would only appear when over 31 days. You could 
> set the cell font colour to red for more effect.

> When in Okay condition nothing shows but when in Debtor condition the 
> word Debtor would be in red.

> Going on from Tony's reply Eureka allows negative numbers to displayed 
> in {Red} or [Green} or [Blue} etc using the Format-Number option:
>     #,###0.00:{Red}#,###.00    OR  #,###0.00:{Green}#,###.00 etc

Colours need to be specified in Square brackets.
You can also define your own 0.00[Red] for example, but how to get it to
do something useful?
`
> You could use a formula in D11 such as:
> =If(Today()-B11>=31,C11*-1,C11)

Sorry that doesn't do anything here... Possibly because both B11 and Cll
are empty cells.

The only occupied cells in this test sheet are:
All with Invoice date. 1/7/2012
Dll with =Today()-A11+1
E11 with {=IF(Dll>=31,"Debtor",IF(D11<31,"Okay"))}

I've noted your shortened form. =If(D11>=31,"Debtor","Okay")

> This would display the cell contents black when less than 31 days
> and red when over 31 days the cell contents have been made negative so 
> that the amount would subtract from any calculation carried out using 
> this cell.

The problem is not getting it to display in [Red] but change from Black to
Red when the debt becomes aged.

> Hope this is of some help

Thanks
Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6154

On 15 Aug, dave@triffid.co.uk wrote:
In article <9baca5bf52.JohnyBoy@john.bryan86.fsnet.co.uk>,
   John Bryan <john@bryan86.fsnet.co.uk> wrote:
{Snippy]
 `
> > You could use a formula in D11 such as:
> > =If(Today()-B11>=31,C11*-1,C11)

As I mentioned a few days ago, that formula doesn't do anything here.

What is it supposed to do?
How does it effect the debt turning red?

Thanks
Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6164

Dave,

You might like to try the following.
Assuming A10 contains the date (say 1/July/2012) and that the formula 
for calculating the number of days old is TODAY()-A10+1 (I think was 
what was agreed but if not you will need to alter the following). Note 
that this formula occurs 3 time, twice positive and once negative

In D10 put
IF(TODAY()-A10+1>31,-(TODAY()-A10+1),TODAY()-A10+1)

This gives a positive value of the age if it is less than (or equal 
to) 31 and a negative value of it if it is greater than 31. You then 
need to give that cell a number format of
#;[Red]#

Hope that works
-- 
Cheers

Julian

[toc] | [prev] | [next] | [standalone]

#6166

In article <8b6baec152.JulianFry@julianfry.orpheusnet.co.uk>,
   Julian Fry <julainfry@tiscali.co.uk> wrote:
> Dave,

> You might like to try the following.
> Assuming A10 contains the date (say 1/July/2012) and that the formula 
> for calculating the number of days old is TODAY()-A10+1 (I think was 
> what was agreed but if not you will need to alter the following). Note 
> that this formula occurs 3 time, twice positive and once negative

> In D10 put
> IF(TODAY()-A10+1>31,-(TODAY()-A10+1),TODAY()-A10+1)

> This gives a positive value of the age if it is less than (or equal 
> to) 31 and a negative value of it if it is greater than 31. You then 
> need to give that cell a number format of
> #;[Red]#

> Hope that works

Thanks Julian,
That works exactly as I want, ecxellent.

Thanks
Dave

-- 

Dave Triffid

[toc] | [prev] | [next] | [standalone]

#6167

In article <52c1b933e9dave@triffid.co.uk>,
   Dave Symes <dave@triffid.co.uk> wrote:

[Snippy]

> Thanks Julian,
> That works exactly as I want, ecxellent.
                                 ^^ 
> Thanks
> Dave

Or even xc
D

-- 

Dave Triffid

[toc] | [prev] | [standalone]

Back to top | Article view | comp.sys.acorn.misc

csiph-web