need help in excel........

**Nazik Abbas** · 9th February 2012, 10:52 AM

Main excel mein 1 sheet bna rha hon, jis mein employees ki date of appointment mention ki hai, aur phir main chahta hon k aaj tk onko kam kiye hoey jitny year, month aur days hoey hain, wo next column mein aa jaen, Plz koi aisa formula batain,
For example
Date of appointment= 06-01-2002 ho tu aaj tk is employee ko kam kiya hoa arsa ye hoga 03-01-10 mtlb 10year, 1 month and 3 days.
Plz help..........

**farooq talhar** · 9th February 2012, 11:32 AM

IS SEY AP KA KAAM BAN JAYE GAA

**Nazik Abbas** · 9th February 2012, 11:47 AM

1 cell mein ekathy aa nhi aa skty??

**syar** · 9th February 2012, 03:37 PM

I assume Cell A1 m aap ki joining date ha b1 ya kisi bhe cell jahan par aap result cahahte hain.

Code:

=IF(DATEDIF(A1,TODAY(),"y")=0,"",DATEDIF(A1,TODAY(),"y")&" years ")&IF(DATEDIF(A1,TODAY(),"ym")=0,"",DATEDIF(A1,TODAY(),"ym") &" months ")&DATEDIF(A1,TODAY(),"md")&" days"

Change references accordingly. yani a1 ko apni marze k mutabiq change kar lain.
dusra is m today() ka function istimal hoa ha jo k har roz date aik din add kare ga.

regards,