Forumla

[tuzdevil]

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

[Bob Phillips]

=DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months
"&DATEDIF(A1,A2,"md")&" days"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"tuzdevil" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[Toppers]

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
>
>