Hi :) Perhaps format the cell as a date format? ie, if in doubt, cheat. I'm not sure it will work but it's worth a try :) Regards from Tom :)
--- On Thu, 22/3/12, Essex Lad <[email protected]> wrote: From: Essex Lad <[email protected]> Subject: [libreoffice-users] Date Difference formula required in Calc 3.5 To: [email protected] Date: Thursday, 22 March, 2012, 18:41 I realise that I can get a date difference of days or years in Calc, but what is needed is a way of getting a result in Years/Months/Days - any thoughts would be very welcome Dave H. -- View this message in context: http://nabble.documentfoundation.org/Date-Difference-formula-required-in-Calc-3-5-tp3849407p3849407.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: [email protected] 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: [email protected] 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
