On 07/19/14 21:34, Brian Barker wrote: > At 20:27 19/07/2014 -0400, James Lockie wrote: >> I want the years since a date and today. I tried this function: >> =YEARS(7/16/2012,TODAY(),1) >> but it returns 1900. > > Your first argument is 7 divided by 16 divided by 2,012. This is > approximately 0.00022, representing - as a date and time - nineteen seconds > after midnight on the date origin. So I'd expect the result to be 115. But in > any case it won't have anything to do with a date in July 2012. > > The arguments of YEARS() need to be numeric dates, so I think you need > something like > =YEARS(DATE(2012,7,16),TODAY(),1) > or > =YEARS(DATEVALUE("7/16/2012"),TODAY(),1) > > I trust this helps. > > Brian Barker > > I tried: =YEARS(DATE(2012,7,16),TODAY(),1) I still get "1900". The cell format is YYYY.
-- To unsubscribe e-mail to: users+unsubscr...@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