close Change the way you learn with CCI Online Coaching   view more
Home > Community > EXCEL TIPS AND TRICKS > Forum


Please Wait ..

Sign-in to your account

Username:
Password:

Remember Me

Forgot your password?

Sign-up now


Join CAclubindia.com and Share your Knowledge. Registered members get a chance to interact at Forum, Ask Query, Comment etc.

EXCEL TIPS AND TRICKS



Owner : CA.Madhavan
579 Members
Created : 09/08/2008 13:01:18




Browse by Category




Popular Communities

Current Discusions Discussion Page


How to find age in yr,months and days???

By : CA.Madhavan
On : 27 September 2009 		How to find age in yr,months and days???

here is the formula in simple way.......

Copy this formula in C column and enter values in A and B....=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

 

By : Rajesh
On : 02 June 2010 		Re: Help

Sir,

I could not do that.. Pls give me the illustration...

 




Reply to this Discussion




You need to be logged in to post reply