=ROUNDUP(YEARFRAC(B1,A1),0)

You need to enable the Analysis ToolPak to use this function. To do
this, Tools Addins. Check the box Analysis ToolPak

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=375004