Calculation of Age.

[Ashish Khobragade]

When I am trying to find age using DATEDIF function in excel 2007 it is giving #value error.

 

[NARAYANK991]

Hi ,

Can you post the complete formula , and specify what the values are that DATEDIF is using ?

Narayan

 

[Khalid NGO]

Hi,

Check if any date looks like a date but it is not a valid date or a text string.

Quoting Chip Pearson:

If Date1 is later than Date2, DATEDIF will return a #NUM! error. If either Date1 or Date2 is not a valid date, DATEDIF will return a #VALUE error.

http://www.cpearson.com/excel/datedif.aspx

Otherwise, post a sample as stated above.

Regards,

 

[achu]

Hi,

please check it....

Private Sub CommandButton1_Click()
    Dim name As String
    Dim age As Date
    Dim enddate As Date
    Dim gender As String
    Dim c As String
  
  

   enddate = Range("A1").Value = Format("DD/MM/YYYY")
   name = InputBox("Enter your name", "Please type What is your name")
   gender = InputBox("Enter your Gender type", "Please Type Gender type ( Male/Female)")
   If gender = "Male" Then
       gender = "Mr."
       Else
       gender = "Mrs."
       End If
   age = InputBox("Enter Your Date of birth", "DD/MM/YYYY" & "- " & "Achyutanand")
  
   c = Application.WorksheetFunction.Days360(age, Now()) / 360
  
  MsgBox gender & "  " & name & "--   " & "your  Age is :" & "-" & Application.WorksheetFunction.Round(c, 0) & " " & "Years Only", vbMsgBoxHelpButton, "For Help Call :- Achyutanand"
  
End Sub

 

[bobhc]

@ achu, your code would be better if you posted with the code tags.
I have put them in for you.

 

[achu]

Thank You sir,

but i am trying to use datedif insted of days360 but geting errror