Again, it stripped all the spaced?? So, there it is with spaces changed to .
Date.......Month.....Day.....Weekday.....Julian.....week.of.year
01/01/18...1.........1.......Monday.......1...........1
01/02/18...1.........2.......Tuesday......2...........1
01/03/18...1.........3.......Wednesday....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
Priority:normal
Not sure why this mailing list screws up the text. Did it in a text editor, so
assumed it could handle it without screwing up the formating to much, but it
did?
DateMonthDayWeekdayJulianweek of year
01/01/1811Monday11
01/02/1812Tuesday21
01/03/1813Wednesday31
Seems it doesn't handle tabs, so changed them to blanks.
Some other stuff got thrown in there that didn't exist in the text??
On 13 Jul 2018 at 1:20, Michael D. Setzer II wrote:
=Not fully clear on what you want, but this is what I did in a little test.
Did this with mono font, but list might change things so they don't line up,
but sould be easy to figure out.
DateMonthDay60;WeekdayJulianweek of year01/01/1811=Monday1;1
01/02/1812=Tuesday20;101/03/1813=Wednesday360;1
The first date was in A15, and A16 was just A15+1Column B just had =month(A15)
to get Month
Column C just had =day(A15) to get day
Column D to get day of Week
=INDEX($J$1:$J$7,WEEKDAY(A15))
$J$1:$J$7 have Sunday thru Saturday
Column E to calculate the Julian Day of Year
=A15-DATE(YEAR(A15),1,1)+1
Column F to get week of year
=INT(E15/7)+1
One could just use the text command andto make whatever combination
one might 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 { 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, how can I put the days date (number only) and week
0; number and day-number-of-the-year in one cell?Particularly in
0; cell A5, B5...etc which are all cells that contain only the day/font
0; number of the month.
Heres
0; a link to the Calc calendar template Im trying to use-
https://extensions.libreoffice.org/templates/calendar-creator
The
0; template is very useful and I dont want to interfere or mess up/span
0; the calendar creation- which it does perfectly.
Thank
0; you,
Carl
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy
