Ask Your Question
0

Calc week number problem [solved]

asked 2018-12-23 01:05:42 +0200

PDA1 gravatar image

updated 2018-12-28 08:02:55 +0200

ebot gravatar image

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)C:\fakepath\Day of Week, Week Number & Day of Year.ods

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-12-23 13:07:04 +0200

ebot gravatar image

Look at this answer by @Lupp

edit flag offensive delete link more

Comments

I already know how to get the week number. The problem was solved.

=IF(WEEKDAY(C12)=1,WEEKNUM(C12,1),"")

PDA1 gravatar imagePDA1 ( 2018-12-28 02:01:00 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-12-23 01:05:42 +0200

Seen: 64 times

Last updated: Dec 28 '18