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
