How to calculate age?

[fatammag]

Hello all,

I have a column called Date of Birth and a column called Age.

The Date of Birth is formatting using Date in English US locale (E.g. 15-Feb-1980).
The Age is formatting as Number.

I need to calculate the Age.
Which is the proper way to do this?

Do I have to use a today or now function?

Thank you in advance.

[AliGW]

Welcome to the forum.

Try this:

=DATEDIF(A1,TODAY(),"y")

where A1 contains the DoB.

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

[fatammag]

Thank you for your reply, AliGW.

Unfortunately the DATEDIF is not working.

A message there's a probelm with this formula appear.

[AliGW]

It will work, but I need to see a sample workbook.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[fatammag]

Here's the attachment.

Book1.xlsx

[AliGW]

Yes, it works:

=DATEDIF(A2,TODAY(),"Y")

For your Greek locale:

=DATEDIF(A2;TODAY();"Y")

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B
1	Date of Birth	Age
2	25-Mar-2018	4
3	17-Sep-2000	21
4	21-Feb-1980	42

Sheet: Sheet1

[fatammag]

What did you done and it worked?
I used the exactly code myself.

Only the Greek locale is working.

[AliGW]

That's why we need to know your location. The formula is automatically updated to your locale when you open the workbook, so my formula using commas converts to your formula using semi-colons.

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank those who have helped you by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[fatammag]

Thank you, AliGW for your help!

[AliGW]

You're welcome.