Forumla

Giganews Newsgroups
Subject: Forumla
Posted by:  tuzdevil (tuzdevil.28pvfz_1149154201.662@excelforum-nospam.com)
Date: Thu, 1 Jun 2006

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?action=getinfo&userid=34999
View this thread:http://www.excelforum.com/showthread.php?threadid=547387

Replies