Re: $$Excel-Macros$$ calculating age with months

2011-09-09 Thread Venkat CV
Hi Sunny, What ..Result not. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * * * On Fri, Sep 9, 2011 at 9:54 PM, XLS S wrote: > Great!!! But Result not. > > > On Fri, Sep 9, 2011 at

Re: $$Excel-Macros$$ calculating age with months

2011-09-09 Thread XLS S
Great!!! But Result not. On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV wrote: > Hi Varun, > > See if Helps Attached... > > *Best Regards,* > *Venkat * > *Chennai* > *My Linked in profile > * > > > > On Thu, Sep 8, 2011 at

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread MURALI NAGARAJAN
Dear varun, There is one more formula available. ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days" For Example:Age is 51 Years, 8 Months and 7 Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body gu

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread MURALI NAGARAJAN
Dear varun, You can use below mentioned formulas.. =DATEDIF(C8,TODAY(),"y") =For Year =DATEDIF(C8,TODAY(),"ym") =For Month =DATEDIF(C8,TODAY(),"md") =For Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel w

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread XLS S
Hey Varun , thy this =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread NOORAIN ANSARI
Use it ="Year "& DATEDIF(E7,F7,"y")& " Days "&DATEDIF(E7,F7,"d") On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards > > Varun Chawla > > -- > >

Re: $$Excel-Macros$$ calculating age with months

2011-09-08 Thread Ahmed Honest
Dear Varun, Try to use Datedif function, if you are familiar with it or just google it you will get the solution in seconds. On Thu, Sep 8, 2011 at 11:27 AM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards > > Varun