Results 1 to 2 of 2

Thread: Formatting date difference in LibreOffice calc.

  1. #1
    Join Date
    Jul 2011
    Location
    /Europe/Netherlands
    Beans
    382
    Distro
    Kubuntu 14.04 Trusty Tahr

    Formatting date difference in LibreOffice calc.

    I'm keeping a small spreadsheet of electronic devices I have purchased over the years. In one column there is the date of purchase.

    Assuming C is the column with purchase dates the following function can calculate the age of the device in days with:
    Code:
    DAYS(NOW();C1)
    This function just gives the days as integer. What I would like to do is put that difference into a nicer format like "1 year, 30 days" or something similar. Is this possible with the formula function of LO Calc?
    "I believe humans get a lot done, not because we're smart, but because we have thumbs so we can make coffee." --Flash Rosenberg
    formerly 'known' as Euroman

  2. #2
    Join Date
    Jul 2011
    Location
    /Europe/Netherlands
    Beans
    382
    Distro
    Kubuntu 14.04 Trusty Tahr

    Re: Formatting date difference in LibreOffice calc.

    *bump*
    "I believe humans get a lot done, not because we're smart, but because we have thumbs so we can make coffee." --Flash Rosenberg
    formerly 'known' as Euroman

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •