Re: $$Excel-Macros$$ age month days calculations - Reg

Thanks noorain babu..!! sir this command is very useful for me, Thanks so much for u. On Sat, Jun 23, 2012 at 12:08 AM, NOORAIN ANSARI wrote: > Dear Mothilal, > > If you don't want in Text Format Please use > > =DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in > custom yy mm d

Re: $$Excel-Macros$$ age month days calculations - Reg

Thanks for all replying to me ( sorry for delay) Thanks with Mothilal On Sat, Jun 23, 2012 at 12:19 PM, Suman wrote: > Great noorain babu..!! > > Regards, > @Suman > Send on the move with Galexy y. > On Jun 23, 2012 12:09 AM, "NOORAIN ANSARI" > wrote: > >> Dear Mothilal, >> >> If you don't w

Re: $$Excel-Macros$$ age month days calculations - Reg

Great noorain babu..!! Regards, @Suman Send on the move with Galexy y. On Jun 23, 2012 12:09 AM, "NOORAIN ANSARI" wrote: > Dear Mothilal, > > If you don't want in Text Format Please use > > =DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in > custom yy mm dd > > See attached sheet

Re: $$Excel-Macros$$ age month days calculations - Reg

Dear Mothilal, If you don't want in Text Format Please use =DATEDIF(D2,E2,"d") select formula cell, press ctrl+1 and type in custom yy mm dd See attached sheet -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Fri, Jun 22, 2012 at 12:55 PM, jmothilal

Re: $$Excel-Macros$$ age month days calculations - Reg

       DatedDiff = "Year= " & ArrResult(0) & " | Month= " & ArrResult(1) & >> " | Day= " & ArrResult(2) >>    End If >>    Erase ArrStart >>    Erase ArrEnd >>    Erase ArrResult >> End Function >> >> >>

RE: $$Excel-Macros$$ age month days calculations - Reg

nction > > > http://excelpoweruser.blogspot.in/2012/01/how-to-calculate-date-difference.h > tml > > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Be

RE: $$Excel-Macros$$ age month days calculations - Reg

ction http://excelpoweruser.blogspot.in/2012/01/how-to-calculate-date-difference.h tml Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rohan Young Sent: 22 June 2012 4:05 To: excel-m

Re: $$Excel-Macros$$ age month days calculations - Reg

try this =+DATEDIF(A1,NOW(),"y")&" Years, "&DATEDIF(A1,NOW(),"ym")&" Months, "&DATEDIF(A1,NOW(),"md")&" Days " Regds On Fri, Jun 22, 2012 at 1:29 PM, Suman wrote: > Hi Dear ! > Please use this formula if its help you. > =Text(Today()-that cell which contain ur birth date,"yy") > > Regards, > @S

Re: $$Excel-Macros$$ age month days calculations - Reg

Hi Dear ! Please use this formula if its help you. =Text(Today()-that cell which contain ur birth date,"yy") Regards, @Suman Send on the move with Galexy y. On Jun 22, 2012 12:56 PM, "jmothilal" wrote: > > Dear any one > > i want find age month days calculations in between two days. pls help me

Re: $$Excel-Macros$$ age month days calculations - Reg

Thanks On Fri, Jun 22, 2012 at 1:04 PM, Excel Vba wrote: > Hi J. Mothilal**, > > Try datedif funtions. > > =datedif(A1,B1,"Y") for years > =datedif(A1,B1,"ym") for months > =datedif(A1,B1,"md") for days > > whereas in cell A1, type oldest date or date from which you want to > calculate, > and in

Re: $$Excel-Macros$$ age month days calculations - Reg

Hi J. Mothilal**, Try datedif funtions. =datedif(A1,B1,"Y") for years =datedif(A1,B1,"ym") for months =datedif(A1,B1,"md") for days whereas in cell A1, type oldest date or date from which you want to calculate, and in cell B1, type the newest date or date till which you want to calculate. On F

$$Excel-Macros$$ age month days calculations - Reg

Dear any one i want find age month days calculations in between two days. pls help me thanks with -- *J.Mothilal : **Universal Computer Systems : # 16, Brindavan Complex :Otteri, Vellore-2* -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titl