{"id":364429,"date":"2021-11-08T19:00:02","date_gmt":"2021-11-08T16:00:02","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-calculate-age-in-microsoft-excel\/"},"modified":"2021-11-08T19:00:02","modified_gmt":"2021-11-08T16:00:02","slug":"how-to-calculate-age-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/","title":{"rendered":"#How to Calculate Age in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a41fcc2d0107\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a41fcc2d0107\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/#How_to_Calculate_Age_in_Years\" >How to Calculate Age in Years<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/#How_to_Calculate_Age_in_Months\" >How to Calculate Age in Months<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/#How_to_Calculate_Age_in_Days\" >How to Calculate Age in Days<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/#How_to_Calculate_Age_in_Years_Months_and_Days_at_the_Same_Time\" >How to Calculate Age in Years, Months, and Days at the Same Time<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-calculate-age-in-microsoft-excel\/#How_to_Calculate_Age_on_a_Specific_Date\" >How to Calculate Age on a Specific Date<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Calculate Age in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-731027\" srcset=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=398&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 400w, https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1 1200w\" sizes=\"auto, 400w, 1200w\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel Logo\" width=\"1200\" height=\"675\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>To find someone or something\u2019s age in Microsoft Excel, you can use a function that displays the age in years, months, and even days. We\u2019ll show you how to use this function in your Excel spreadsheet.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> We\u2019ve used the day-month-year format in the examples in this guide, but you can use any date format you prefer.<\/p><\/blockquote>\n<p><strong>RELATED:<\/strong> <strong><em>Why Do You Need Formulas and Functions?<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Age_in_Years\"><\/span>How to Calculate Age in Years<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To calculate someone\u2019s age in years, use Excel\u2019s <code>DATEDIF<\/code> function. This function takes the date of birth as an input and then generates the age as an output.<\/p>\n<p>For this example, we\u2019ll use the following spreadsheet. In the spreadsheet, the date of birth is specified in the B2 cell, and we\u2019ll display the age in the C2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757478\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/1-age-years-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A sample spreadsheet to find age in years in Excel.\" width=\"650\" height=\"254\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>First, we\u2019ll click the C2 cell where we want to display the age in years.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757479\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/2-c2-cell-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the C2 cell in the spreadsheet in Excel.\" width=\"650\" height=\"281\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the C2 cell, we\u2019ll type the following function and press Enter. In this function, \u201cB2\u201d refers to the date of birth, \u201cTODAY()\u201d finds today\u2019s date, and \u201cY\u201d indicates that you wish to see the age in years.<\/p>\n<pre>=DATEDIF(B2,TODAY(),\"Y\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757481\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/3-enter-year-formula.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Type =DATEDIF(B2,TODAY(),&quot;Y&quot;) in the C2 cell and press Enter in Excel.\" width=\"650\" height=\"232\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And im<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/social-mediaa\/\" data-internallinksmanager029f6b8e52c=\"1\" title=\"Social Media\" target=\"_blank\" rel=\"noopener\">media<\/a>tely, you\u2019ll see the completed age in the C2 cell.<\/p>\n<blockquote class=\"admonishment_note\"><p><strong>Note:<\/strong> If you see a date instead of years in the C2 cell, then in Excel\u2019s Home &gt; Number section, click the \u201cDate\u201d drop-down menu and select \u201c<a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">General<\/a>.\u201d You\u2019ll now see years instead of a date.<\/p><\/blockquote>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757482\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/4-age-years-answer.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Age in years in Excel.\" width=\"650\" height=\"245\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Excel is so powerful that you can even <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/413456\/how-to-get-excel-to-calculate-uncertainty\/\">use it to calculate uncertainty.<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>How to Get Microsoft Excel to Calculate Uncertainty<\/em><\/strong><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Age_in_Months\"><\/span>How to Calculate Age in Months<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>You can use the <code>DATEDIF<\/code> function to find someone\u2019s age in months, too.<\/p>\n<p>For this example, again, we\u2019ll use the data from the above spreadsheet, which looks like this:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757483\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/5-age-months-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A sample spreadsheet to find age in months in Excel.\" width=\"650\" height=\"253\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ll click the C2 cell where we want to display the age in months.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757484\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/6-c2-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the C2 cell in the spreadsheet in Excel.\" width=\"650\" height=\"292\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the C2 cell, we\u2019ll type the following function. The \u201cM\u201d argument here tells the function to display the result in months.<\/p>\n<pre>=DATEDIF(B2,TODAY(),\"M\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-757485 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/7-enter-month-formula.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter =DATEDIF(B2,TODAY(),&quot;M&quot;) in the C2 cell in Excel.\" width=\"650\" height=\"246\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Enter and you\u2019ll see the age in months in the C2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757486\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/8-age-months-answer.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Age in months in Excel.\" width=\"650\" height=\"236\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Age_in_Days\"><\/span><a rel=\"nofollow noopener\" target=\"_blank\" name=\"autotoc_anchor_2\">How to Calculate Age in Days<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Excel\u2019s <code>DATEDIF<\/code> function is so powerful that you can use it to find someone\u2019s age in days as well.<\/p>\n<p>To show you a demonstration, we\u2019ll use the following spreadsheet:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757487\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/9-age-days-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A sample spreadsheet to find age in days in Excel.\" width=\"650\" height=\"242\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ll click the C2 cell where we want to display the age in days.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757488\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/10-c2-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the C2 cell in the spreadsheet in Excel.\" width=\"650\" height=\"252\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the C2 cell, we\u2019ll type the following function. In this function, the \u201cD\u201d argument tells the function to display the age in days.<\/p>\n<pre>=DATEDIF(B2,TODAY(),\"D\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757489\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/11-enter-day-formula.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Type =DATEDIF(B2,TODAY(),&quot;D&quot;) in the C2 cell in Excel.\" width=\"650\" height=\"229\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Enter and you\u2019ll see the age in days in the C2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757490\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/12-age-days-answer.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Age in days in Excel.\" width=\"650\" height=\"268\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can use Excel to <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/731002\/how-to-add-or-subtract-dates-in-microsoft-excel\/\">add and subtract dates, too.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Age_in_Years_Months_and_Days_at_the_Same_Time\"><\/span>How to Calculate Age in Years, Months, and Days at the Same Time<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>To display someone\u2019s age in years, months, and days at the same time, use the <code>DATEDIF<\/code> function with all the arguments combined. You can also <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/279719\/how-to-combine-text-from-multiple-cells-into-one-cell-in-excel\/\">combine text from multiple cells into one cell in Excel.<\/p>\n<p>We\u2019ll use the following spreadsheet for the calculation:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757491\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/13-age-combination-spreadsheet.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A sample spreadsheet to find age in years, months, and days in Excel.\" width=\"650\" height=\"232\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In this spreadsheet, we\u2019ll click the C2 cell, type the following function, and press Enter:<\/p>\n<pre>=DATEDIF(B2,TODAY(),\"Y\") &amp; \" Years \" &amp; DATEDIF(B2,TODAY(),\"YM\") &amp; \" Months \" &amp; DATEDIF(B2,TODAY(),\"MD\") &amp; \" Days\"<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-757493 size-full\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/14-enter-age-formula.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter =DATEDIF(B2,TODAY(),&quot;Y&quot;) &amp; &quot; Years &quot; &amp; DATEDIF(B2,TODAY(),&quot;YM&quot;) &amp; &quot; Months &quot; &amp; DATEDIF(B2,TODAY(),&quot;MD&quot;) &amp; &quot; Days&quot; in the C2 cell and press Enter in Excel.\" width=\"650\" height=\"220\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the C2 cell, you\u2019ll see the age in years, months, and days.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757494\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/15-age-combination-answer.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Age in years, months, and days in Excel.\" width=\"650\" height=\"211\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"How_to_Calculate_Age_on_a_Specific_Date\"><\/span>How to Calculate Age on a Specific Date<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>With Excel\u2019s <code>DATEDIF<\/code> function, you can go as far as to finding someone\u2019s age on a specific date.<\/p>\n<p>To show you how this works, we\u2019ll use the following spreadsheet. In the C2 cell, we\u2019ve specified the date on which we want to find the age.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757495\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/16-specific-date.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"A specific date in the C2 cell in Excel.\" width=\"650\" height=\"251\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>We\u2019ll click the D2 cell where we want to show the age on the specified date.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757496\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/17-d2-cell.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click the D2 cell in Excel.\" width=\"650\" height=\"235\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>In the D2 cell, we\u2019ll type the following function. In this function, \u201cC2\u201d refers to the cell where we\u2019ve entered the specific date, on which the answer will be based:<\/p>\n<pre>=DATEDIF(B2,C2,\"Y\")<\/pre>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757497\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/18-enter-specific-formula.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Enter =DATEDIF(B2,C2,&quot;Y&quot;) in the D2 cell in Excel.\" width=\"650\" height=\"226\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Press Enter and you\u2019ll see the age in years in the D2 cell.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-757499\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/09\/19-specific-formula-answer.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Age on a specific date in the D2 cell in Excel.\" width=\"650\" height=\"263\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>And that\u2019s how you find someone or something\u2019s oldness in Microsoft Excel!<\/p>\n<hr\/>\n<p>With Excel, did you know you can <a rel=\"nofollow noopener\" target=\"_blank\" href=\"https:\/\/www.howtogeek.com\/403419\/use-excel-to-calculate-how-many-more-days-there-are-until-your-next-birthday\/\">find how many days until an event? This is super useful if you\u2019re looking forward to an important event in your life!<\/p>\n<p><strong>RELATED:<\/strong> <strong><em>Use Excel to Calculate How Many Days Until an Event<\/em><\/strong><\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/757469\/how-to-calculate-age-in-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Calculate Age in Microsoft Excel&#8221; To find someone or something\u2019s age in Microsoft Excel, you can use a function that displays the age in years, months, and even days. We\u2019ll show you how to use this function in your Excel spreadsheet. Note: We\u2019ve used the day-month-year format in the examples in this guide,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":364430,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/MS-excel-logo-675.png?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-364429","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/364429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=364429"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/364429\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/364430"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=364429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=364429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=364429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}