Date: prev next · Thread: first prev next last
2020 Archives by date, by thread · List index

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 number 44557.

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
="Monday "&DAY(January.$A5)

Depending on exactly what you need, have you considered using

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
Privacy Policy:


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.