Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Brian Barker
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,

Re: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Carl Winerich
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-

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Michael D. Setzer II
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

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Michael D. Setzer II
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

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Michael D. Setzer II
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

Re: [SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Carl Winerich
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

[SUSPECT] Re: [libreoffice-users] date, day number, week number in one cell

2018-07-12 Thread Brian Barker
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

Re: [libreoffice-users] date, day number, week number in one cell

2018-07-11 Thread Carl Winerich
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

[libreoffice-users] date, day number, week number in one cell

2018-07-11 Thread Carl Winerich
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