Groups | Search | Server Info | Login | Register
Groups > comp.sys.acorn.misc > #6034
| From | M Harding <riscos@mdharding.org.uk> |
|---|---|
| Subject | Re: Eureka spreadsheet question. |
| Newsgroups | comp.sys.acorn.misc |
| Date | 2012-08-07 11:22 +0100 |
| Message-ID | <52bb75bba1riscos@mdharding.org.uk> (permalink) |
| References | <52bb25d3c0dave@triffid.co.uk> <f6a92bbb52.david@david.wisnia.net> <52bb5ca19bdave@triffid.co.uk> |
| Organization | None |
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
Back to comp.sys.acorn.misc | Previous | Next — Previous in thread | Next in thread | Find similar
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