Hi,

Assuming your data is in A1 and that 0.08 is a decimal representation

B1 = DATE(2000+FLOOR(A1,1),1,MOD(A1,1)*365)

You could use the data at this point by custom formatting it,

or you could add two more cells with
=MONTH(B1)
=YEAR(B1)

and custom format them. Either way, it will work.


--
KellTainer
------------------------------------------------------------------------
KellTainer's Profile: http://www.excelforum.com/member.php...o&userid=34322
View this thread: http://www.excelforum.com/showthread...hreadid=544500