{"id":1646,"date":"2022-07-04T22:25:41","date_gmt":"2022-07-04T14:25:41","guid":{"rendered":"https:\/\/www.excelchamp.net\/?p=1646"},"modified":"2022-07-11T06:27:37","modified_gmt":"2022-07-10T22:27:37","slug":"find-age-in-years-within-microsoft-excel-video-tutorial","status":"publish","type":"post","link":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/","title":{"rendered":"Find Age in Years within Microsoft Excel [Video Tutorial]"},"content":{"rendered":"<p><strong>Wondering How To Find the Age in Years from Date of Birth, in Microsoft Excel?<\/strong><\/p>\n<p>See multiple ways to calculate Age in Excel from any date of birth.<\/p>\n<p><strong>This simple, step-by-step tutorial on finding the age in Excel from date of birth or any other date, work\u00a0on Microsoft Office 365, Microsoft Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007 &amp; Excel 2003 too.<\/strong><\/p>\n<p>We cover Microsoft Excel Functions &amp; Formulas that allow you to calculate the following things in Excel:<\/p>\n<ol>\n<li>Find the age in Years<\/li>\n<li>Find the Age in Months<\/li>\n<li>Find the Age in Days<\/li>\n<li>Finding the exact age in Years, Months &amp; Days.<\/li>\n<li>Combining Years &amp; Months to create a Text String the way we want.<\/li>\n<\/ol>\n<p><iframe title=\"Find Age in Years From Date of Birth With Excel\" width=\"1200\" height=\"675\" src=\"https:\/\/www.youtube.com\/embed\/PQphir5F-Pc?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture\" allowfullscreen><\/iframe><\/p>\n<h2>Here&#8217;s how to calculate the number of years since the date of birth<\/h2>\n<p>Not only the years we can also calculate the months. I will show you multiple techniques to calculate the age in years, months &amp; days.<\/p>\n<p>If you want a whole number or you want the age as a fraction, there are so many ways to do it.<\/p>\n<p>What we want to calculate is the age in years &#8211;\u00a0 something like Age is 55 years. Or Age is 55.56 years.<\/p>\n<p>Before we start i want to highlight to you that the date of birth that you are using should be a date field so you can select it and make sure the formatting is not General or text, but it should be set as a short date or any kind of date.<\/p>\n<blockquote><p>To calculate the years,\u00a0 the formula is extremely simple. We will be using the <strong>DATEDIF<\/strong> function of Excel.<br \/>\n<strong>=DATEDIF(DateofBirth, TODAY(), &#8220;Y&#8221;)<\/strong><\/p><\/blockquote>\n<p>Similarly, we can calculate the age in months too.<\/p>\n<blockquote><p><strong>=DATEDIF(DateofBirth, TODAY(), &#8220;M&#8221;)<\/strong><\/p><\/blockquote>\n<p>This will result in the number of months from the date of birth to today&#8217;s date. You might see a huge number like 666 here.<\/p>\n<p>But you may not want this.\u00a0 Perhaps we only want how many months after the 55 whole years have elapsed.<\/p>\n<p>In this case,\u00a0 we modify the formula from only &#8220;M&#8221; to &#8220;YM&#8221;<\/p>\n<blockquote><p><strong>=DATEDIF(DateofBirth, TODAY(), &#8220;YM&#8221;)<\/strong><\/p><\/blockquote>\n<p>YM means it is only the months after the completed years. By doing this we can see that only six months have elapsed after 55 years.<\/p>\n<p>Finally, we only need the days that have elapsed after the completed months in the age.<\/p>\n<blockquote><p><strong>=DATEDIF(DateofBirth, TODAY(), &#8220;D&#8221;)<\/strong><\/p><\/blockquote>\n<p>This will tell you that 20,000 days have passed from the date of birth, but, of course, we don&#8217;t want this.<\/p>\n<p><strong>So you change D to MD. The &#8220;MD&#8221; tells Excel to calculate how many days after the month have elapsed.\u00a0<\/strong><\/p>\n<p>As you can see, we have the age calculated in different cells &#8211; the age is 55 years 6 months and 9 days exactly till today.<\/p>\n<p>If you wish to see a complete combined date, you can use the CONCAT function to combine multiple formulas, or use the &amp; to combine text as well.<\/p>\n<p>As an example, we can write<\/p>\n<blockquote><p><strong>=CONCAT(DATEDIF(dateofbirth,TODAY(),&#8221;Y&#8221;),&#8221; Years, &#8220;,DATEDIF(dateofbirth,TODAY(),&#8221;YM&#8221;),&#8221; Months &amp; &#8220;,DATEDIF(dateofbirth,TODAY(),&#8221;MD&#8221;),&#8221; Days&#8221;)<\/strong><\/p><\/blockquote>\n<p>For a DateofBirth date of <strong>6-December-1966<\/strong>, it generates, <strong>55 Years, 6 Months &amp; 28 Days.<\/strong><\/p>\n<p>Hope you find this DATEDIF function quite handy for such use. Do give it a try and let us know how you use it.<\/p>\n<p>Cheers,<br \/>\nVinai<\/p>\n<p><strong>Recommended Reading for Next Steps: <\/strong><\/p>\n<ol>\n<li><a href=\"https:\/\/www.excelchamp.net\/using-date-time-functions-in-excel\/\">Using Date &amp; Time Functions in Excel<\/a><\/li>\n<li><a href=\"https:\/\/www.excelchamp.net\/difference-between-2-dates-without-the-weekends\/\">Difference Between 2 Dates, Without the Weekends<\/a><\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"<p>Wondering How To Find the Age in Years from Date of Birth, in Microsoft Excel? See multiple ways to calculate Age in Excel from any date of birth. This simple, step-by-step tutorial on finding the age in Excel from date of birth or any other date, work\u00a0on Microsoft Office 365, Microsoft Excel 2019, Excel 2016, &#8230; <a title=\"Find Age in Years within Microsoft Excel [Video Tutorial]\" class=\"read-more\" href=\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\" aria-label=\"More on Find Age in Years within Microsoft Excel [Video Tutorial]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"generate_page_header":"","footnotes":"","_jetpack_memberships_contains_paid_content":false},"categories":[5,6],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp<\/title>\n<meta name=\"description\" content=\"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp\" \/>\n<meta property=\"og:description\" content=\"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"ExcelChamp\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\" \/>\n<meta property=\"article:published_time\" content=\"2022-07-04T14:25:41+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-07-10T22:27:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1\" \/>\n\t<meta property=\"og:image:width\" content=\"331\" \/>\n\t<meta property=\"og:image:height\" content=\"314\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vinai Prakash\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vinai Prakash\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\"},\"author\":{\"name\":\"Vinai Prakash\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"headline\":\"Find Age in Years within Microsoft Excel [Video Tutorial]\",\"datePublished\":\"2022-07-04T14:25:41+00:00\",\"dateModified\":\"2022-07-10T22:27:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\"},\"wordCount\":573,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"articleSection\":[\"Excel Functions\",\"Excel In-Built Functionality\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\",\"url\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\",\"name\":\"Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp\",\"isPartOf\":{\"@id\":\"https:\/\/www.excelchamp.net\/#website\"},\"datePublished\":\"2022-07-04T14:25:41+00:00\",\"dateModified\":\"2022-07-10T22:27:37+00:00\",\"description\":\"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.excelchamp.net\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Find Age in Years within Microsoft Excel [Video Tutorial]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.excelchamp.net\/#website\",\"url\":\"https:\/\/www.excelchamp.net\/\",\"name\":\"ExcelChamp\",\"description\":\"Solving Everyday Problems With Excel\",\"publisher\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.excelchamp.net\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba\",\"name\":\"Vinai Prakash\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1\",\"width\":487,\"height\":720,\"caption\":\"Vinai Prakash\"},\"logo\":{\"@id\":\"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/\"},\"description\":\"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.\",\"sameAs\":[\"https:\/\/ExcelChamp.Net\",\"https:\/\/www.facebook.com\/profile.php?id=100079767634794\",\"https:\/\/www.linkedin.com\/in\/vinaiprakash\/\",\"https:\/\/www.youtube.com\/user\/ExcelChamp\"],\"url\":\"https:\/\/www.excelchamp.net\/author\/ppfdd\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp","description":"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp","og_description":"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.","og_url":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/","og_site_name":"ExcelChamp","article_publisher":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_author":"https:\/\/www.facebook.com\/profile.php?id=100079767634794","article_published_time":"2022-07-04T14:25:41+00:00","article_modified_time":"2022-07-10T22:27:37+00:00","og_image":[{"width":331,"height":314,"url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash-e1654524348231.png?fit=331%2C314&ssl=1","type":"image\/png"}],"author":"Vinai Prakash","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Vinai Prakash","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#article","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/"},"author":{"name":"Vinai Prakash","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"headline":"Find Age in Years within Microsoft Excel [Video Tutorial]","datePublished":"2022-07-04T14:25:41+00:00","dateModified":"2022-07-10T22:27:37+00:00","mainEntityOfPage":{"@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/"},"wordCount":573,"commentCount":0,"publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"articleSection":["Excel Functions","Excel In-Built Functionality"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/","url":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/","name":"Find Age in Years within Microsoft Excel [Video Tutorial] - ExcelChamp","isPartOf":{"@id":"https:\/\/www.excelchamp.net\/#website"},"datePublished":"2022-07-04T14:25:41+00:00","dateModified":"2022-07-10T22:27:37+00:00","description":"Multiple Ways to Find the Age in Years within Microsoft Excel. Using simple Excel Functions, presented by Vinai Prakash, ExcelChamp.","breadcrumb":{"@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.excelchamp.net\/find-age-in-years-within-microsoft-excel-video-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.excelchamp.net\/"},{"@type":"ListItem","position":2,"name":"Find Age in Years within Microsoft Excel [Video Tutorial]"}]},{"@type":"WebSite","@id":"https:\/\/www.excelchamp.net\/#website","url":"https:\/\/www.excelchamp.net\/","name":"ExcelChamp","description":"Solving Everyday Problems With Excel","publisher":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.excelchamp.net\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/e82f27afcc1c8f354753c53f433284ba","name":"Vinai Prakash","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/","url":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","contentUrl":"https:\/\/i0.wp.com\/www.excelchamp.net\/wp-content\/uploads\/2022\/06\/VinaiPrakash.png?fit=487%2C720&ssl=1","width":487,"height":720,"caption":"Vinai Prakash"},"logo":{"@id":"https:\/\/www.excelchamp.net\/#\/schema\/person\/image\/"},"description":"Vinai Prakash is the founder and master trainer of ExcelChamp.Net. Vinai has over 30 years of experience in using Excel, and is a Data Warehousing &amp; Business Intelligence Professional. Vinai has coached and trained over 30,000 professionals in using Excel, Power BI, Python, SQL, and regularly runs Excel Data Analysis, Excel Dashboard MasterClass, Excel for Beginners, Advanced Excel MasterClass online and all over the world. Vinai's Videos on YouTube channel and his blog articles and newsletters are read by thousands of subscribers all over the world. Vinai lives in Singapore with his wife and 2 kids.","sameAs":["https:\/\/ExcelChamp.Net","https:\/\/www.facebook.com\/profile.php?id=100079767634794","https:\/\/www.linkedin.com\/in\/vinaiprakash\/","https:\/\/www.youtube.com\/user\/ExcelChamp"],"url":"https:\/\/www.excelchamp.net\/author\/ppfdd\/"}]}},"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"","_links":{"self":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/1646"}],"collection":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/comments?post=1646"}],"version-history":[{"count":3,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/1646\/revisions"}],"predecessor-version":[{"id":1649,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/posts\/1646\/revisions\/1649"}],"wp:attachment":[{"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/media?parent=1646"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/categories?post=1646"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.excelchamp.net\/wp-json\/wp\/v2\/tags?post=1646"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}