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:
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