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

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 WinerichLook@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+unsubscribe@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+unsubscribe@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+unsubscribe@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