Groups | Search | Server Info | Login | Register

Groups > comp.sys.acorn.misc > #6035

Re: Eureka spreadsheet question.

Show all headers | View raw

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

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