[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [libreoffice-users] Calc week number problem


At 15:56 22/12/2018 -0500, Dotty Peter wrote:
I found a LO Calc spreadsheet that provides the year's day number, remaining days and week number.

Found? Most people compose spreadsheets.

It's attached herein.

Er, it's not: the mailing list processor normally strips attached files before messages are distributed. In any case, no-one really want to mend your spreadsheet for you; instead, you should be prepared to explain the nub of your problem so that others can address it directly.

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 [...] so that beside each "Sun" (the row in which "Sun" appears) the correct week number will be provided?

And what would you like in that cell if the row is not a Sunday? I'm guessing perhaps nothing.

I'm hoping that your "Sun" is actually a date, formatted as "NN". In that case, you may just need something like
=IF(WEEKDAY(Xn)=1;WEEKNUM(Xn;1);"")
- where Xn is the cell containing the date formatted to appear as "Sun", "Mon", etc. or any other column in the same row containing that date.

If your "Sun" is text, either use the date cell from which it is derived as above or else something like
=IF(Xn="Sun";WEEKNUM(Yn;1);"")
- where Xn is the cell containing the text "Sun", "Mon", etc. and Yn is a cell in the same row containing the actual date.

Here's another possibility:
=IF(WEEKDAY(Xn)=1;TEXT(Xn;"WW");"")

And another:
=IF(WEEKDAY(Xn)=1;Xn;"")
- and format the column as "WW".

Thanks, Peter (at least I think that's my name...today)

Incidentally, when writing to strangers, please have the courtesy, maturity, and good sense to put your name (just *a* name?) in the real name field of your messages. Some people are called Dot, but no-one's called ".". Thanks.

I trust this helps.

Brian Barker


--
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

References:
[libreoffice-users] Calc week number problem"." <Look@iPadRing.net>
Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.