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.
View this message in context:
Sent from the Users mailing list archive at Nabble.com.
The number of days is simply the difference between the 2 cell values
(=B1-A1 for instance) because all spreadsheet dates are day numbers
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
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: email@example.com
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
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