Not clear on what he wanted without seeing the sheet.
Did a test with column a have dates from 1/1/2019 to 12/31/2019
Column B had =Days(a1,"12/31/2018") to get the day of year
Column C had =Weeknum(a1) to get week number
Column D created the Text formula to create the listing.
=TEXT(DAYS(A1,"12/31/2018"),"000")&" day within year, WEEK
"&TEXT(WEEKNUM(A1),"0")&" of year, day of week "&TEXT(A1,"DDD")
001 day within year, WEEK 1 of year, day of week Tue
002 day within year, WEEK 1 of year, day of week Wed
003 day within year, WEEK 1 of year, day of week Thu
004 day within year, WEEK 1 of year, day of week Fri
005 day within year, WEEK 1 of year, day of week Sat
006 day within year, WEEK 2 of year, day of week Sun
Not sure if that would help at all.
On 22 Dec 2018 at 15:56, . wrote:
To: users@global.libreoffice.org
From: "." <l...@ipadring.net>
Subject: [libreoffice-users] Calc week number problem
Date sent: Sat, 22 Dec 2018 15:56:46 -0500
> I found a LO Calc spreadsheet that provides the year´s day number,
> remaining days and week number. It's attached herein.Depending upon the
> year it´s tedious to move each week number, which
> begins on Sunday, so that the week number is in the row which
> contains a Sunday.Is there a way to modify the sheet in columns F, J, N,
> R, V, Z so
> that beside each "Sun" (the row in which "Sun" appears) the correct
> week number will be provided? Thanks,Peter (at least I think that's my
> name...today) p { margin-bottom: 0.1in; line-height: 120%; }p.western {
> font-family: "Ubuntu"; }p.cjk { font-size: 10pt; }
> --
> 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
+------------------------------------------------------------+
Michael D. Setzer II - Computer Science Instructor (Retired)
mailto:mi...@guam.net
mailto:msetze...@gmail.com
Guam - Where America's Day Begins
G4L Disk Imaging Project maintainer
http://sourceforge.net/projects/g4l/
+------------------------------------------------------------+
http://setiathome.berkeley.edu (Original)
Number of Seti Units Returned: 19,471
Processing time: 32 years, 290 days, 12 hours, 58 minutes
(Total Hours: 287,489)
BOINC@HOME CREDITS
ROSETTA 66308620.404055 | ABC 16613838.513356
SETI 109773059.474214 | EINSTEIN 141794097.999240
--
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
