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
noorain.ans...@gmail.comwrote:
Dear Mothilal,
If you don't want in Text Format Please use
=DATEDIF(D2,E2,d) select formula cell, press ctrl+1 and type
Great noorain babu..!!
Regards,
@Suman
Send on the move with Galexy y.
On Jun 23, 2012 12:09 AM, NOORAIN ANSARI noorain.ans...@gmail.com 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
Thanks
On Fri, Jun 22, 2012 at 1:04 PM, Excel Vba excelvba.lear...@gmail.comwrote:
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
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 gjmothi...@gmail.com wrote:
Dear any one
i want find age month days calculations in between two days.
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 ksuman1...@gmail.com wrote:
Hi Dear !
Please use this formula if its help you.
=Text(Today()-that cell which contain ur birth date,yy)
Regards,
@Suman
]
-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-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ age month days calculations - Reg
try this
=+DATEDIF(A1,NOW(),y) Years, DATEDIF(A1
To: excel-macros@googlegroups.com
Subject: 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 ksuman1...@gmail.com wrote:
Hi Dear !
Please use
@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rohan Young
Sent: 22 June 2012 4:05
To: excel-macros@googlegroups.com
Subject: 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
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