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
- 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
- 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:
- 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.
To unsubscribe e-mail to: email@example.com
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Impressum (Legal Info)
: 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