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: [email protected]
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
