Formula to find the age

algrigore

Hello,

Can you please help me with an info?

Is there any formula that can be used to calculate the age if we have the date of birth?

Thanks

Accepted answers

AntonMineev

Hi @algrigore!

You can make formula "(Today Date - Birthday)/365"

Снимок экрана 2021-05-13 в 11.29.59.png

abhay.kanik

hi @algrigore ,

You will need one more line item to hold current date and the third line item which will be number formatted and formula which will be "(Current date - Date of birth)/365 "which will give you age in years.

Thanks

Abhay

AntonMineev

Yes, there is currently no formula that returns the current day. The community has an idea about this, you can support it.
In practice, we are doing an integration that loads the current date into the desired cell every day.

If the accuracy of the calculation is not so important to you and there is no way to load the date, a good solution would be to use the formula from Chris below (with YEAR).

All comments

AntonMineev

Hi @algrigore!

You can make formula "(Today Date - Birthday)/365"

Снимок экрана 2021-05-13 в 11.29.59.png

abhay.kanik

hi @algrigore ,

Thanks

Abhay

algrigore

Hey, @AntonMineev

Thanks, there is a formula also for the current date ?or I need to import some data?

ChrisAHeathcote

@algrigore

How about =YEAR(Today) - YEAR(Birthday)

Its a little simpler than the solution offered.

abhay.kanik

@ChrisAHeathcote

I think it will not give half years or any fraction like 4.6, 7.5 I am not sure, definitely it can be used to get result in integer value only.

Thanks

Abhay

ChrisAHeathcote

@abhay.kanik

Yes, you are right.

The solution will only provide whole numbers.

AntonMineev

If the accuracy of the calculation is not so important to you and there is no way to load the date, a good solution would be to use the formula from Chris below (with YEAR).

Quick Links

Can you help?

Unanswered questions

import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…