Re: [libreoffice-users] Date number has 5 digits

At 09:27 29/12/2020 -0500, Peter Dutton wrote:
> In cell A4 is the following code;
> ="Monday"+January.$A5

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
=TEXT(January.$A5;"NNNND")
instead?

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