You could download Laurent Longre's MoreFunc addin which is freely
downloadable at:

http://xcell05.free.fr/


and use the DATE.DIFF function

"tuzdevil" wrote:


I am stuck on how to create this formula..

I have Date A in 1 box.. and Date B in another...

Date A - Date B (which calculates the difference in days..) and then
converts that to years..
Example: 20/04/05 and 27/05/06 which will show as a result in another
box as 1 year 1 month 7 days

No matter how many books I read none of them are helpful!!

Thanks:)


--
tuzdevil
------------------------------------------------------------------------
tuzdevil's Profile: http://www.excelforum.com/member.php...o&userid=34999
View this thread: http://www.excelforum.com/showthread...hreadid=547387