At 09:27 29/12/2020 -0500, Peter Dutton wrote:
In cell A4 is the following code;
Do you mean that plus sign - or perhaps an ampersand?
January.$A5 has the number 27 in it (December 27).
I'm not sure what you think you mean by adding "(December 27)"! What
I suspect you have in that cell is not the number 27 but instead the
date 27 December 2021 (which indeed will be a Monday) - but formatted
so as to display only the numerical day part of that date.
What appears in cell A4 as a result is- Monday 44557.
Good. You are concatenating the text "Monday" with the value of that
date, and in this context no regard is had to the formatting of the
cell. The actual value in your cell for 27 December 2021 is 44557,
which is the number of days from the start date until that day.
What is needed is- Monday 27
I've tried reformatting cell A4 to a date or text or a number to no success.
Reformatting a cell already containing a value does not change the
value - merely the way it is displayed. Your cell still contains the
Any idea how to fix this?
You need to extract the day number part of the date value before you
concatenate it with the text "Monday". To do that, use
Depending on exactly what you need, have you considered using
I trust this helps.
To unsubscribe e-mail to: firstname.lastname@example.org
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