{"id":22864,"date":"2026-01-21T02:00:03","date_gmt":"2026-01-21T02:00:03","guid":{"rendered":"https:\/\/www.youragecalculator.com\/blog\/?p=22864"},"modified":"2026-01-21T02:00:03","modified_gmt":"2026-01-21T02:00:03","slug":"how-to-calculate-age-in-google-sheets-step-by-step-tutorial","status":"publish","type":"post","link":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/","title":{"rendered":"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial"},"content":{"rendered":"\n

<\/p>\n\n\n\n

If you have ever wondered how to calculate age in Google Sheets<\/a>, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.<\/p>\n\n\n\n

\n
\"\"<\/figure>\n<\/figure>\n\n\n\n

To begin, you will need a cell containing the birth date. For example, suppose cell A2 contains the date of birth. One of the most accurate ways to calculate age is by using the DATEDIF<\/code> function, which compares two dates and returns the difference in years, months, or days. For age calculation in years, you can type:<\/p>\n\n\n\n

=DATEDIF(A2, TODAY(), \"Y\")<\/code><\/p>\n\n\n\n

This formula checks the date in A2 against the current date and calculates the full years between them. The reason DATEDIF<\/code> works so well is that it takes leap years and month differences into account, giving you a precise result.<\/p>\n\n\n\n

If you want to show the age in a more detailed way, such as \u201c25 years, 3 months\u201d, you can combine multiple DATEDIF<\/code> functions like this:<\/p>\n\n\n\n

=DATEDIF(A2, TODAY(), \"Y\") & \" years, \" & DATEDIF(A2, TODAY(), \"YM\") & \" months\"<\/code><\/p>\n\n\n\n

Google Sheets also allows you to format the output or use conditional formatting to highlight certain age ranges, which is especially helpful for HR departments or school administrators. Another advantage is that you can copy and paste these formulas across rows to calculate the age for multiple people at once without having to redo the work.<\/p>\n\n\n\n

Accuracy matters when dealing with date calculations, so it is important to ensure your date of birth cells are in proper date format and not stored as text. You can check this by selecting the cell and setting the format to Date under the Format menu. Keeping the data clean ensures your formulas produce the right results every time.<\/p>\n\n\n\n

Knowing how to calculate age in Google Sheets can save a lot of time and reduce human error compared to manual calculation. Whether you\u2019re building a personal spreadsheet, running a school database, or managing employee information, mastering this skill will make your data work smarter and faster.<\/p>\n","protected":false},"excerpt":{"rendered":"

If you have ever wondered how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without … <\/p>\n

Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":22865,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1],"tags":[],"class_list":["post-22864","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-age-calculation-guides"],"yoast_head":"\n\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial - Age Calculation Blog<\/title>\n<meta name=\"description\" content=\"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.\" \/>\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.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial\" \/>\n<meta property=\"og:description\" content=\"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"Age Calculation Blog\" \/>\n<meta property=\"article:published_time\" content=\"2026-01-21T02:00:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"640\" \/>\n\t<meta property=\"og:image:height\" content=\"427\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Age Calculation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Age Calculation\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/\",\"url\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/\",\"name\":\"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial - Age Calculation Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg\",\"datePublished\":\"2026-01-21T02:00:03+00:00\",\"author\":{\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/4d3136a8f9014e6edd5524700dbdc41a\"},\"description\":\"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage\",\"url\":\"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg\",\"contentUrl\":\"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg\",\"width\":640,\"height\":427},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.youragecalculator.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/#website\",\"url\":\"https:\/\/www.youragecalculator.com\/blog\/\",\"name\":\"Age Calculation Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.youragecalculator.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/4d3136a8f9014e6edd5524700dbdc41a\",\"name\":\"Age Calculation\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/44b2a84c24995151771121c4cc7d35d0a256330227fc2ce45528a164d7fd0b61?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/44b2a84c24995151771121c4cc7d35d0a256330227fc2ce45528a164d7fd0b61?s=96&d=mm&r=g\",\"caption\":\"Age Calculation\"},\"sameAs\":[\"https:\/\/www.youragecalculator.com\/blog\"],\"url\":\"https:\/\/www.youragecalculator.com\/blog\/author\/yourblog2628\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial - Age Calculation Blog","description":"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.","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.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/","og_locale":"en_US","og_type":"article","og_title":"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial","og_description":"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.","og_url":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/","og_site_name":"Age Calculation Blog","article_published_time":"2026-01-21T02:00:03+00:00","og_image":[{"width":640,"height":427,"url":"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg","type":"image\/jpeg"}],"author":"Age Calculation","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Age Calculation","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/","url":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/","name":"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial - Age Calculation Blog","isPartOf":{"@id":"https:\/\/www.youragecalculator.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage"},"thumbnailUrl":"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg","datePublished":"2026-01-21T02:00:03+00:00","author":{"@id":"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/4d3136a8f9014e6edd5524700dbdc41a"},"description":"If you have ever wondered\u00a0how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without needing any extra tools.","breadcrumb":{"@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#primaryimage","url":"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg","contentUrl":"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg","width":640,"height":427},{"@type":"BreadcrumbList","@id":"https:\/\/www.youragecalculator.com\/blog\/how-to-calculate-age-in-google-sheets-step-by-step-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.youragecalculator.com\/blog\/"},{"@type":"ListItem","position":2,"name":"\u00a0How to Calculate Age in Google Sheets Step\u2011by\u2011Step Tutorial"}]},{"@type":"WebSite","@id":"https:\/\/www.youragecalculator.com\/blog\/#website","url":"https:\/\/www.youragecalculator.com\/blog\/","name":"Age Calculation Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.youragecalculator.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/4d3136a8f9014e6edd5524700dbdc41a","name":"Age Calculation","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.youragecalculator.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/44b2a84c24995151771121c4cc7d35d0a256330227fc2ce45528a164d7fd0b61?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/44b2a84c24995151771121c4cc7d35d0a256330227fc2ce45528a164d7fd0b61?s=96&d=mm&r=g","caption":"Age Calculation"},"sameAs":["https:\/\/www.youragecalculator.com\/blog"],"url":"https:\/\/www.youragecalculator.com\/blog\/author\/yourblog2628\/"}]}},"jetpack_featured_media_url":"https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg","uagb_featured_image_src":{"full":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg",640,427,false],"thumbnail":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131-150x150.jpg",150,150,true],"medium":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131-300x200.jpg",300,200,true],"medium_large":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg",640,427,false],"large":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg",640,427,false],"1536x1536":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg",640,427,false],"2048x2048":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131.jpg",640,427,false],"yarpp-thumbnail":["https:\/\/www.youragecalculator.com\/blog\/wp-content\/uploads\/2026\/01\/pexels-olly-3768131-120x120.jpg",120,120,true]},"uagb_author_info":{"display_name":"Age Calculation","author_link":"https:\/\/www.youragecalculator.com\/blog\/author\/yourblog2628\/"},"uagb_comment_info":0,"uagb_excerpt":"If you have ever wondered how to calculate age in Google Sheets, you are not alone. Many people need to quickly find someone\u2019s age based on their birth date for everything from employee records to school registries or even personal tracking. Google Sheets offers built\u2011in functions that make this process simple, accurate, and flexible \u2014 without…","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/posts\/22864","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/comments?post=22864"}],"version-history":[{"count":2,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/posts\/22864\/revisions"}],"predecessor-version":[{"id":22871,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/posts\/22864\/revisions\/22871"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/media\/22865"}],"wp:attachment":[{"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/media?parent=22864"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/categories?post=22864"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.youragecalculator.com\/blog\/wp-json\/wp\/v2\/tags?post=22864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}