formula

[muddassir.hussain]

Dear users,

I'm trying to get a formula for:

Joining End Total Service
Date Date Total days Year Month Days
01/01/2000 20/06/2010 3823

since this is like one year 5 months and 20 days or whatever...I need to generate a formula for that.

 

[Claus Busch]

Hi,

Am Wed, 13 Feb 2013 02:57:34 -0800 (PST) schrieb
(e-mail address removed):

Joining End Total Service
Date Date Total days Year Month Days
01/01/2000 20/06/2010 3823

since this is like one year 5 months and 20 days or whatever...I need to generate a formula for that.

for years:
=DATEDIF(A3,B3,"y")
for months:
=DATEDIF(A3,B3,"ym")
for days:
=DATEDIF(A3,B3,"md")


Regards
Claus Busch