Maybe you could use =datedif()

You can find lots of info at Chip Pearson's site:
http://www.cpearson.com/excel/datedif.htm

(=datedif() was only documented in xl2k's help.)

"rmriba" wrote:

Hello, Gurus:

I have multiple licenses (potentially 50+), each one with an expiration
date. I have a sheet with expiration date column and another column
with the difference between expiration date and current date. The
display shows the result in days.

I would like it to show it in years-months-days format. Excel has a
similar function for converting to hrs, sec, etc., but no such beauty
(apparently) for this case. Any help will be appreciated.

--

Dave Peterson