Re: [libreoffice-users] formula years since date
At 22:44 19/07/2014 -0400, James Lockie wrote: 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 tried: =YEARS(DATE(2012,7,16),TODAY(),1) I still get 1900. The cell format is . Oh, well you will. The result of this formula is 2 (meaning two years) but if you interpret this number as a date it represents two days after the date origin - which is indeed a date within the year 1900. At 22:47 19/07/2014 -0400, James Lockie wrote: I set the cell format to numeric and got what I want. :-) Good-oh! Brian Barker -- 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
[libreoffice-users] formula years since date
I want the years since a date and today. I tried this function: =YEARS(7/16/2012,TODAY(),1) but it returns 1900. -- 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
Re: [libreoffice-users] formula years since date
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 -- 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
Re: [libreoffice-users] formula years since date
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 . -- 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
Re: [libreoffice-users] formula years since date
On 07/19/14 22:44, James wrote: 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 . I set the cell format to numeric and got what I want. :-) -- 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