Re: [libreoffice-users] Calc week number problem

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:                   "." <Look@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+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


+------------------------------------------------------------+
 Michael D. Setzer II - Computer Science Instructor (Retired)     
 mailto:mikes@guam.net                            
 mailto:msetzerii@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+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