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


Hi :)
I think for data-entry it is best to enter the date as 
01/24/2012
and then have the cells formatted to display that in whichever way you want.  It feels a bit weird 
to enter a date as numbers and then see it displayed as word&numbers but doing it that way makes 
everything else fall into place neatly.  

I'm in England so it feels a tad weird to type the day and month 'the wrong way around', lol.  I 
think it picks-up on whatever your global localisation is set at.  Mine is set to UK so i type 
dd/mm/yyyy.  
Regards from
Tom :)



--- On Tue, 24/1/12, MSwhip <send28files@yahoo.com> wrote:

From: MSwhip <send28files@yahoo.com>
Subject: [libreoffice-users] Re: How to enter Dates in a format to allow the counting of days 
lapsed  between  a "from a date" cell and a "to a date' cell
To: users@global.libreoffice.org
Date: Tuesday, 24 January, 2012, 12:58

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.

-- 
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


-- 
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

Context


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.