In article <5a8685a4...@mdharding.org.uk
M Harding <ris...@mdharding.org.uk
> ...than Tippex.) [Does anyone remember Tippex?]
Hi Michael, what fun... :-)
Yes, I still have a bottle of Tippex correction fluid here on my office
desk... Mmnn! Come to think about it, I also have a Tippex snail
correction tape, and still use both... :-)
> I discovered a lot of useful tricks over the years. One, is that if I
> use numerical slots,
> and put the date into A1 (as 17.3.23) it shows as <17 Mar 2023>
> If in A2 I insert A1+7 the slot returns <24 Mar 2023>.
> If in A3 I insert A2-A1 the slot returns <7>
> Is there no such facility in Eureka?
Yes that works the same in Eureka providing you've set the cell to display
a date as "dd mmm yyyy" (Sans quotes).
> (At this point, Martyn, I usually discover I've totally misunderstood
> the nature of the question.)
Michael, you were kind of on the same track as our chat, though we were
specifically noting the lack off, or the inaccurate results of a Function.
But then I'm quite often confused myself, as you know. :-/
The original question was about the function. "=Days(cell,cell)" Which for
some reason does not exist in Eureka.
Followed by a similar but inaccurate function "=DAYS360(C2,B2)" which I
modified to make the inaccurate result a little closer to reality.
This of course can be overcome in Eureka by using the formula...
"=$B$2-$C$2" Where B2 has todays date "=TODAY()" and C2 has the start date
"17 Mar 2022" (Sans quotes).
Anyway, whatever... It's nice to chat with friends.