There are many ways to calculate a person's age in Excel.
To calculate the age of a person on date since their birthdate:
=INT((date-birthdate)/365.25)
To figure their age as of today, date can be replaced with a function like TODAY() or NOW(). The INT() function is used to return only the number of complete years.
Let's say suppose Cell A1 contains "13-11-1984", then you can find person's age by enterring the following formula as
=INT((A1-birthdate)/365.25)
To calculate age in terms of years, months, and days, DATEDIF is a handy function. The following formula is similar to the one above.
=DATEDIF(A1,TODAY(),"Y") & " years, " & DATEDIF(A1,TODAY(),"YM") & " months, " & DATEDIF(A1,TODAY(),"MD") & " days"
Well we are an IT organization i.e. Computine LTD reputed IT organization in London providing outstanding IT and web based services in all over the world. We are known as a best London IT service providers. We offers Cisco network services, application development services London, Mobile Development services , Network support services London and much more. If you need more details just log on to in www.computine.co.uk
ReplyDeleteNice post. We appreciate that. Given that ASP.NET is interested in many years, there are numerous developers that are expert at utilizing it to develop the best of apps. Establishing an application in Dot net training in Chennai with the assistance of this systems fairly cost-effective. The easy energy for this will allow the creators to perform the granted occupation inside the stipulated time period. And this also permits supply of quality products and services in dot net platform.Take a look to my blog Dot Net Training Academy in Chennai
ReplyDeleteThanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
ReplyDeleteRegards,
Angularjs training in chennai|Angularjs training chennai
Your post on excel advanced training is really useful. I agree with your thoughts, knowledge on excel is mandatory for everyone. Excel Training in Chennai | Advanced Excel Training in Chennai
ReplyDeleteWe share this advance excel related post is really excellent. I agree that our concepts for this post, I've learned from new knowledge excel related.Thanks you so much.
ReplyDeleteSelenium Training in Chennai
Selenium Course in Chennai
wow. finally get to know the birthday from excel
ReplyDeleteMBA in
Business Analytics
online aptitude
training
MBA in Marketing Managment
MBA in Event Managment
Learn core java
online
Great post very nice
ReplyDeleteAdvance Excel Training
Thanks for your informative article. Softlogic Helo you to get the EXCEL TRAINING WITH PLACMENT IN CHENNAI. More Details Visit the Link
ReplyDelete
ReplyDeleteThanks for sharing this valuable information to our vision. You have posted a trust worthy blog keep sharing.
Regards,
cloud computing courses in chennai | Data Science Training in Chennai | digital Marketing Training in Chennai | salesforce training in chennai | software testing training in chennai
The purpose of the Excel application is to allow users to collect like data in a specific location for current and/or future use. custom excel dashboards
ReplyDelete