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: http://nabble.documentfoundation.org/How-to-enter-Dates-in-a-format-to-allow-the-counting-of-days-lapsed-between-a-from-a-date-cell-and-al-tp3671720p3684597.html 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 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: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ 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