Calculate age in excel

0 votes

My date of birth is 23-05-2015(dd/mm/yyyy) and I need to figure out how old I am. I attempted to use the formula =DATEDIF(C3,TODAY(),"Y") but received a #VALUE! error. The formula appears as =DATEDIF("23/05/2015",42866,"Y" when I evaluate it. I believe the date format (dd/mm/yyyy) is to blame.

 is there any method where I can achieve this?             enter image description here

enter image description here

Oct 2 in Others by Kithuzzz
• 20,660 points
57 views

1 answer to this question.

0 votes

Write =Today-C3 and then press Ctrl+1 and select Number for the format. 

Or try this:

=DATEDIF(DATE(YEAR(A24),MONTH(A24),DAY(A24)),TODAY(),"Y")

answered Oct 3 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

Pivot Chart Table in Excel To Calculate the Count and Display the Chart

It should look something like this: READ MORE

answered Nov 6 in Others by narikkadan
• 37,660 points
37 views
0 votes
1 answer

Calculate the number of days between a cell and today in excel?

Use the DATEDIF function when you want ...READ MORE

answered Nov 8 in Others by gaurav
• 22,040 points
33 views
0 votes
1 answer

How to calculate percentage of an autosum field in excel

The fact that I was using the ...READ MORE

answered Nov 11 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
145 views
0 votes
1 answer

Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

answered Feb 16 in Others by Edureka
• 13,640 points
248 views
0 votes
0 answers

Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

Feb 17 in Others by Edureka
• 13,640 points
112 views
0 votes
1 answer

IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

answered Feb 18 in Others by gaurav
• 22,040 points
79 views
0 votes
1 answer

How do you calculate the Quintile for groups of rows in Excel?

Use this formula: =MAX(1,ROUNDUP(10*PERCENTRANK($C:$C,$C2,4),0)) To divide into whichever many ...READ MORE

answered Oct 17 in Others by narikkadan
• 37,660 points
40 views
0 votes
1 answer
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP