formula

M

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

Claus Busch

Hi,

Am Wed, 13 Feb 2013 02:57:34 -0800 (PST) schrieb
[email protected]:
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.
Click to expand...

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


Regards
Claus Busch
 
Top