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