Excelent !!!! Rajan ....fine solution
Chilexcel
2012/6/22 Suman <ksuman1...@gmail.com>:
> Tkanks Rajan ji
>
> Regards,
> @Suman
> Send on the move with Galexy y.
>
> On Jun 22, 2012 5:58 PM, "Rajan_Verma" <rajanverma1...@gmail.com> wrote:
>>
>> Here are two vba solution for that :
>>
>> 1).
>>
>> Function DOB(rng As Range)
>> DOB = VBA.Format(VBA.DateDiff("d", rng, Date), "yy mm dd")
>> End Function
>>
>> 2).
>>
>> Function DatedDiff(dtStart As Date, dtEnd As Date) As String
>>
>> Dim ArrStart
>> Dim ArrEnd
>> Dim ArrResult
>>
>> ArrStart = Array(Year(dtStart), Month(dtStart), Day(dtStart))
>> ArrEnd = Array(Year(dtEnd), Month(dtEnd), Day(dtEnd))
>> ArrResult = Array(0, 0, 0)
>> If ArrEnd(2) < ArrStart(2) Then
>> ArrEnd(2) = ArrEnd(2) + Day(CDate(ArrEnd(1) & "-1-" & ArrEnd(0)) -
>> 1)
>> ArrEnd(1) = ArrEnd(1) - 1
>> End If
>> ArrResult(2) = ArrEnd(2) - ArrStart(2)
>> If ArrEnd(1) < ArrStart(1) Then
>> ArrEnd(1) = ArrEnd(1) + 12
>> ArrEnd(0) = ArrEnd(0) - 1
>> End If
>> ArrResult(1) = ArrEnd(1) - ArrStart(1)
>> ArrResult(0) = ArrEnd(0) - ArrStart(0)
>> If dtEnd < dtStart Then
>> DatedDiff = "StartDate>EndData=TRUE"
>> Else
>> DatedDiff = "Year= " & ArrResult(0) & " | Month= " & ArrResult(1) &
>> " | Day= " & ArrResult(2)
>> End If
>> Erase ArrStart
>> Erase ArrEnd
>> Erase ArrResult
>> End Function
>>
>>
>> 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-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 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. 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 titles. Poor thread titles, like Please
>> >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>> >> Advice will not get quick attention or may not be answered. 2) Don't
>> >> post a question in the thread of another member. 3) Don't post
>> >> questions regarding breaking or bypassing any security measure. 4)
>> >> Acknowledge the responses you receive, good or bad. 5)
>> >> Cross-promotion of, or links to, forums competitive to this forum in
>> >> signatures are prohibited. NOTE : Don't ever post personal or
>> >> confidential data in a workbook. Forum owners and members are not
>> responsible for any loss.
>> >> ---------------------------------------------------------------------
>> >> --------------------------------- To post to this group, send email
>> >> to excel-macros@googlegroups.com To unsubscribe, send a blank email
>> >> to excel-macros+unsubscr...@googlegroups.com
>> >
>> > --
>> > -- FORUM RULES (986+ members already BANNED for violation) 1) Use
>> > concise, accurate thread titles. Poor thread titles, like Please Help,
>> > Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> > not get quick attention or may not be answered. 2) Don't post a
>> > question in the thread of another member. 3) Don't post questions
>> > regarding breaking or bypassing any security measure. 4) Acknowledge
>> > the responses you receive, good or bad. 5) Cross-promotion of, or
>> > links to, forums competitive to this forum in signatures are
>> > prohibited. NOTE : Don't ever post personal or confidential data in a
>> > workbook. Forum owners and members are not responsible for any loss.
>> > ----------------------------------------------------------------------
>> > -------------------------------- To post to this group, send email to
>> > excel-macros@googlegroups.com To unsubscribe, send a blank email to
>> > excel-macros+unsubscr...@googlegroups.com
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ----------------------------------------------------------------------------
>> --------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
>>
>> --
>> --
>> FORUM RULES (986+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
>> not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> ------------------------------------------------------------------------------------------------------
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> To unsubscribe, send a blank email to
>> excel-macros+unsubscr...@googlegroups.com
>>
>>
> --
> -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,
> accurate thread titles. Poor thread titles, like Please Help, Urgent, Need
> Help, Formula Problem, Code Problem, and Need Advice will not get quick
> attention or may not be answered. 2) Don't post a question in the thread of
> another member. 3) Don't post questions regarding breaking or bypassing any
> security measure. 4) Acknowledge the responses you receive, good or bad. 5)
> Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited. NOTE : Don't ever post personal or confidential
> data in a workbook. Forum owners and members are not responsible for any
> loss.
> ------------------------------------------------------------------------------------------------------
> To post to this group, send email to excel-macros@googlegroups.com To
> unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
--
Visita ; http://sites.google.com/site/chilexcel/Home
Visita ; http://www.youtube.com/user/timextag41
--
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
