Hi Sunny,
What ..Result not.
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
*
*
*
*
On Fri, Sep 9, 2011 at 9:54 PM, XLS S xlst...@gmail.com wrote:
Great!!! But Result not.
On Fri,
Great!!! But Result not.
On Fri, Sep 9, 2011 at 10:39 AM, Venkat CV venkat1@gmail.com wrote:
Hi Varun,
See if Helps Attached...
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71
*
On Thu, Sep 8,
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 varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Use it
=Year DATEDIF(E7,F7,y) Days DATEDIF(E7,F7,d)
On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
Regards
Varun Chawla
--
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 varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate the Age in excel with months
and days.
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 varunchawla...@gmail.comwrote:
Can any body guide me the formula to calculate
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 varunchawla...@gmail.comwrote:
Can any body