Dear Ansar,
You can also use vba version
Function DOB(rng As Range)
DOB = VBA.Format(VBA.DateDiff("d", rng, Date), "yy mm dd")
End Function
On Wed, Dec 28, 2011 at 11:11 AM, Ansar Ellahi wrote:
> please send excel formula
> my accurate date of birth
> from 16/03/1986
> today 28/12/2011
>
>
Datedif doest not appear in function list but its exist in Excel..
Thanks
On Thu, Dec 29, 2011 at 1:55 AM, Maries wrote:
> http://www.cpearson.com/excel/datedif.aspx
>
>
> On Thu, Dec 29, 2011 at 12:09 AM, Aamir Shahzad
> wrote:
>
>> Dear Rajan,
>>
>> Perhaps there is no function "datedif" ava
http://www.cpearson.com/excel/datedif.aspx
On Thu, Dec 29, 2011 at 12:09 AM, Aamir Shahzad wrote:
> Dear Rajan,
>
> Perhaps there is no function "datedif" available in excel 2010, but when I
> copy your formula it's work. Can you brief:
>
> Aamir Shahzad
>
>
> On Wed, Dec 28, 2011 at 6:41 PM, Raj
Dear Rajan,
Perhaps there is no function "datedif" available in excel 2010, but when I
copy your formula it's work. Can you brief:
Aamir Shahzad
On Wed, Dec 28, 2011 at 6:41 PM, Rajan_Verma wrote:
> If Current Date in A1 and Date of Birth in B2 then Put this Function to
> Calculate Age:
>
> =D
If Current Date in A1 and Date of Birth in B2 then Put this Function to
Calculate Age:
=DATEDIF(B2,B1,"Y")&" Year "&DATEDIF(B2,B1,"YM")&" Month
"&DATEDIF(B2,B1,"MD")&" Days"
Please visit this page :
http://excelpoweruser.blogspot.com/2011/12/age-calculation.html
From: excel-macros@goog
