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

Am 24.01.2012 13:58, MSwhip wrote:
This is my reply to all of you that made suggestions or stated your views.
They were all very useful.

With regards to the question about what exactly I was asking, the first
issue was  ...should I enter the date as "24 January 2012," or "January 24
2012"  or '01/24/2012'  or 24/01/2012 for the software to take it as a
number to be deducted from the number represention the second date input of
another cell to form the "from date1 to date2" proposition for it to come up
with the number of days between those 2 dates?

The second issue was the actual way to enter a formula to get the actual
number od days between the 2 cells involved.

Hope I made myself totally clear now.

Thank you

View this message in context:
Sent from the Users mailing list archive at

The number of days is simply the difference between the 2 cell values (=B1-A1 for instance) because all spreadsheet dates are day numbers actually. The possible input formats for dates depend mostly on the locale you are using. Not knowing your locale setting, it is impossible to tell any details. There may be differences between US English and other English locales. That is Tools>Options>LanguageSettings>Languages>Locale Setting (2nd option) and it can be overridden in the cell format dialog.

But regardless of how exactly you type some date, the result will always be displayed in *one particular* number format which is either the number format you applied the cell or some standard format for dates if you did not apply any number format.

Why don't you simply fill out some cells and get a feeling for it? There are many ways to enter a date. There are no clear rules because the details depend on the localization teams for the respective locale.

If your input looks exactly like what you typed and is bound to the left cell border then the input is a text which is *not* a valid date. If your input is right bound and the formula bar shows 2 digits for day and month and 4 digits for the year then you have entered a date.

For unsubscribe instructions e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


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.