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