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