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?

Oct 2, 2022 in Others 616 views

## 1 answer to this question.

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")`

• 63,700 points

## Is there a function in excel to automatically calculate age using date of birth?

Try  =INT((YEARFRAC(TODAY(),B3,1)))  Where cell B3 contains a date like ...READ MORE

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

It should look something like this: READ MORE

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

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

## How to calculate percentage of an autosum field in excel

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

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

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

## Convert Rows to Columns with values in Excel using custom format

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

## IF - ELSE IF - ELSE Structure in Excel

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

## 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

## Creating a function in excel VBA to calculate the average point in a circular set of numbers

I used the following code to determine ...READ MORE