ding:0.5em; }
a.comment-indicator { background:red; display:inline-block;
border:1px solid black; width:0.5em; height:0.5em; }
comment { display:none; }From:Brian
Barker [mailto:b.m.bar...@btinternet.com]
Subject:[libreoffice-users] Adding a / (for
On Sat, 04 Apr 2020 13:45:38 +0100
Brian Barker wrote:
> At 07:50 04/04/2020 -0400, Peter Dutton wrote:
> >Thanks- the "/" works perfectly.
>
> Good-oh!
>
> >Nothing's easy in this world.
>
> Many things are.
>
> >What has been created in the calc sheet is the day number of the
> >year
At 07:50 04/04/2020 -0400, Peter Dutton wrote:
Thanks- the "/" works perfectly.
Good-oh!
Nothing's easy in this world.
Many things are.
What has been created in the calc sheet is the day number of the
year which is followed by the "/". In the cell beside the result is
the remaining
ething to do with
the formatting of the cell but can't figure it out.
Any ideas?
Thanks,
Peter
From:Brian
Barker [mailto:b.m.bar...@btinternet.com]
Subject:[libreoffice-users] Adding a / (forward slash)
Date:Friday,
April 3, 2020, 9:55 PM
To:users@global.libreoffice.o
At 20:24 03/04/2020 -0400, Peter Dutton wrote:
Here's a formula I'm using
=DATEDIF($Begin_Here.$E$76,R4,"d")
The above formula returns the day number of the year where
$Begin_Here.$E$76 [...] the date of 12/31/19
Cell R4 has the date 10 (which is Monday, February 10, 2020)
"10" is not a
Here's a formula I'm using
=DATEDIF($Begin_Here.$E$76,R4,"d")
The above formulareturns the day
number of the year where;
$Begin_Here.$E$76
$Begin_Here is a sheet and $E$76 is a cell (on that sheet)
with the date of 12/31/19
Cell R4
has the date