At 09:04 12/07/2018 -0400, Carl Winerich wrote:
Existing cell (for the month of February) has the following formula;
=$G30-$H30+$D32+$E32+COLUMN(A5)
That stuff points to various parts of the spreadsheet and returns
the correct numeric day number of the month. When I try to concat it
with, say,
Solved the problem.
All I had to do was the following;
Format the selected calendar cell as follows;
DD (then a bunch of spaces) WW
The result returned was the correct calendar date number and the current
week of the year.
Now all I have to figure out is how the get the day-number-of-the-
3...1
On 13 Jul 2018 at 1:37, Michael D. Setzer II wrote:
From:Michael D. Setzer iimsetze...@gmail.com
To:Carl winerichl...@ipadring.net,
users@global.libreoffice.org
Date sent:Fri, 13 Jul 2018 01:37:48 +1000
Subject:Re: [libreoffice-users] date, day number, week
number in one cell
want??
Did the dates all the way to 12/31,
On 11 Jul 2018 at 19:30, Carl Winerich wrote:
To:;users@global.libreoffice.org
From:60;Carl winerichl...@ipadring.net
Subject:;[libreoffice-users] date, day number, week
number in one cell
Date sent:60;Wed, 11 Jul 2018 19:30:41 -0400
p { margi
g.net
Subject:;[libreoffice-users] date, day number, week
number in one cell
Date sent:60;Wed, 11 Jul 2018 19:30:41 -0400
p { margin-bottom: 0.1in; line-height: 120%; }p.western { font-family:Ubuntu;
}p.cjk { font-size: 10pt; }a:link {}
Its
0; back to the same old question;
In
0; a
0; calendar, ho
On 07/12/2018 04:12 AM, Brian Barker
wrote:
At
19:30 11/07/2018 -0400, Carl Winerich wrote:It's back to the same old
question; ...Indeed so - and the answer is very much the same as on the
previous two occasions you have asked this.In a calendar, how can I put
the day's
At 19:30 11/07/2018 -0400, Carl Winerich wrote:
It's back to the same old question; ...
Indeed so - and the answer is very much the same as on the previous
two occasions you have asked this.
In a calendar, how can I put the day's date (number only) and week
number and day-number-of-the-year
My apologies for the messed up format. Here's a better version;
It’s back to the same old question;
In a calendar, how can I put the day’s date (number only) and week
number and day-number-of-the-year in one cell? Particularly in
cell A5, B5...etc which are all cells that contain only the day
n
p { margin-bottom: 0.1in; line-height: 120%; }p.western { font-family:
"Ubuntu"; }p.cjk { font-size: 10pt; }a:link { }
It’s
back to the same old question;
In
a
calendar, how can I put the day’s date (number only) and week
number and day-number-of-the-year in one cell? P