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

Den tis 29 dec. 2020 kl 15:29 skrev Peter Dutton <>:

In cell
          A4 is the following code;


Okay, that would give #VALUE! as a result. With you so far.

          has the number 27 in it (December 27)

December 27 gives me the value 44192, not 27. 27 december 2020 is 44192
dags from 1899-12-30, so 44192 makes way more sense than 27 (which would
rather be 26 january 1900), but let's go on.

          appears in cell A4 as a result is- Monday    44557

No, it's #VALUE! I tested it a few seconds ago.

What is
          needed is- Monday    27

          tried reformatting cell A4 to a date or text or a number to no

If you want 27 December to display as Monday 27, then just format the cell
that way.

1. Enter the date you want to format in a cell. Use the format that
corresponds to your language settings. In my case I would type:
Now use the following as your cell's number format:

Result (in my case):
söndag 27
 If I set the language to US English, it will display:
Sunday 27

Why not Monday, you might ask? Because 27 December 2020 was a Sunday.

          idea how to fix this?

If you want 2020-12-27 to be a Monday, then no. Otherwise, see above.

Kind regards

Johnny Rosenberg



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

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.