{"id":15610,"date":"2023-04-27T18:27:33","date_gmt":"2023-04-27T18:27:33","guid":{"rendered":"https:\/\/officetuts.net\/excel\/?p=15610"},"modified":"2024-02-19T14:52:11","modified_gmt":"2024-02-19T14:52:11","slug":"calculate-the-average-time-between-dates","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/","title":{"rendered":"Calculate the Average Time Between Dates"},"content":{"rendered":"\n<div class=\"wp-block-file\"><a id=\"wp-block-file--media-72c53274-71e5-4448-b2a0-62b17e1457fc\" href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/Calculate-Average-Time-Between-Dates.xlsx\">Calculate-Average-Time-Between-Dates<\/a><a href=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/Calculate-Average-Time-Between-Dates.xlsx\" class=\"wp-block-file__button wp-element-button\" download aria-describedby=\"wp-block-file--media-72c53274-71e5-4448-b2a0-62b17e1457fc\">Download File<\/a><\/div>\n\n\n\n<p>As you might be aware, times and dates in Excel are basically <strong>just numbers<\/strong>. Having that in mind, we can use the same calculations we normally use and apply them to date and time.<\/p>\n\n\n\n<p>In the example below, we will show how to calculate the <strong>average time between two dates<\/strong>.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Calculate the Average Time Between Dates<\/h2>\n\n\n\n<p>To demonstrate how to calculate the average time between dates, we first need the dates. The first thing we need to do with these dates is to order them chronologically, starting from the earliest one:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"108\" height=\"246\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\" alt=\"\" class=\"wp-image-15611\"\/><\/figure>\n\n\n\n<p>Now we need to find the difference among the dates, which can be simply done by subtracting the date in <strong>cell A3 from the date in cell A2<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=A3-A2<\/code><\/pre>\n\n\n\n<p>And will drag this formula till the end of our range. We will end up with the following results:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"398\" height=\"287\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-2.png\" alt=\"\" class=\"wp-image-15612\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-2.png 398w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-2-300x216.png 300w\" sizes=\"(max-width: 398px) 100vw, 398px\" \/><\/figure>\n\n\n\n<p>Bear in mind that the numbers shown as a difference above are shown in days. To calculate the average of these numbers, we would simply need to insert the <strong>AVERAGE formula in cell B10<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=AVERAGE(B3:B9)<\/code><\/pre>\n\n\n\n<p>This will be our result:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"460\" height=\"317\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-3.png\" alt=\"\" class=\"wp-image-15613\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-3.png 460w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-3-300x207.png 300w\" sizes=\"(max-width: 460px) 100vw, 460px\" \/><\/figure>\n\n\n\n<p>To calculate the difference and average time between dates in <strong>months or years<\/strong>, we need to divide our <strong>numbers by 30 (for months) or by 360 (for years)<\/strong>, and we will do this in <strong>columns C and D<\/strong>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=B3\/30 and =B3\/360<\/code><\/pre>\n\n\n\n<p>We will also simply drag our average formula to the right, and end up with the following results:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"468\" height=\"348\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-4.png\" alt=\"\" class=\"wp-image-15614\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-4.png 468w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-4-300x223.png 300w\" sizes=\"(max-width: 468px) 100vw, 468px\" \/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Using A Simpler Formula<\/h2>\n\n\n\n<p>To achieve the same results in the same way but with a formula in one cell, we can use the following formula (located in <strong>cell F2<\/strong>):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>=(A9-A2)\/(COUNT(A2:A9)-1)<\/code><\/pre>\n\n\n\n<p>Since each one of our dates is one after another, we can subtract the last date from the first one, and then divide this number by the total number of dates minus one.<\/p>\n\n\n\n<p>The result of this formula will be the same as in <strong>cell B10, which is 150<\/strong>:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"589\" height=\"360\" src=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-5.png\" alt=\"\" class=\"wp-image-15615\" srcset=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-5.png 589w, https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-5-300x183.png 300w\" sizes=\"(max-width: 589px) 100vw, 589px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>As you might be aware, times and dates in Excel are basically just numbers. Having that in mind, we can use the same&#8230;<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[170],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Calculate the Average Time Between Dates<\/title>\n<meta name=\"description\" content=\"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Calculate the Average Time Between Dates\" \/>\n<meta property=\"og:description\" content=\"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-27T18:27:33+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-19T14:52:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\" \/>\n<meta name=\"author\" content=\"Harun Spahic\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Harun Spahic\" \/>\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:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\"},\"author\":{\"name\":\"Harun Spahic\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\"},\"headline\":\"Calculate the Average Time Between Dates\",\"datePublished\":\"2023-04-27T18:27:33+00:00\",\"dateModified\":\"2024-02-19T14:52:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\"},\"wordCount\":318,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\",\"keywords\":[\"file\"],\"articleSection\":[\"formulas\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\",\"url\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\",\"name\":\"Calculate the Average Time Between Dates\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\",\"datePublished\":\"2023-04-27T18:27:33+00:00\",\"dateModified\":\"2024-02-19T14:52:11+00:00\",\"description\":\"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage\",\"url\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\",\"contentUrl\":\"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png\",\"width\":108,\"height\":246},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Calculate the Average Time Between Dates\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/officetuts.net\/excel\/#website\",\"url\":\"https:\/\/officetuts.net\/excel\/\",\"name\":\"\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/officetuts.net\/excel\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\",\"name\":\"Tomasz Decker\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g\",\"caption\":\"Tomasz Decker\"},\"logo\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\"},\"description\":\"Spreadsheet and Python enthusiast.\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2\",\"name\":\"Harun Spahic\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g\",\"caption\":\"Harun Spahic\"},\"sameAs\":[\"http:\/\/human.bsru.ac.th\/\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Calculate the Average Time Between Dates","description":"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.","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:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/","og_locale":"en_US","og_type":"article","og_title":"Calculate the Average Time Between Dates","og_description":"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.","og_url":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/","article_published_time":"2023-04-27T18:27:33+00:00","article_modified_time":"2024-02-19T14:52:11+00:00","og_image":[{"url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png"}],"author":"Harun Spahic","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Harun Spahic","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/"},"author":{"name":"Harun Spahic","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2"},"headline":"Calculate the Average Time Between Dates","datePublished":"2023-04-27T18:27:33+00:00","dateModified":"2024-02-19T14:52:11+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/"},"wordCount":318,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png","keywords":["file"],"articleSection":["formulas"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/","url":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/","name":"Calculate the Average Time Between Dates","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage"},"image":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage"},"thumbnailUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png","datePublished":"2023-04-27T18:27:33+00:00","dateModified":"2024-02-19T14:52:11+00:00","description":"Learn how to calculate the average time between two dates in Excel. Order dates chronologically and use a simple subtraction formula. Download example file.","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#primaryimage","url":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png","contentUrl":"https:\/\/officetuts.net\/excel\/wp-content\/uploads\/sites\/2\/2023\/04\/word-image-15610-1.png","width":108,"height":246},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/formulas\/calculate-the-average-time-between-dates\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"Calculate the Average Time Between Dates"}]},{"@type":"WebSite","@id":"https:\/\/officetuts.net\/excel\/#website","url":"https:\/\/officetuts.net\/excel\/","name":"","description":"","publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/officetuts.net\/excel\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42","name":"Tomasz Decker","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/18cbe22837193574870ae40ba56bf712?s=96&d=mm&r=g","caption":"Tomasz Decker"},"logo":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/"},"description":"Spreadsheet and Python enthusiast."},{"@type":"Person","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/694491c70f776081acdac4ae41f222a2","name":"Harun Spahic","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b7b887a2249679182be5550a4421a7a9?s=96&d=mm&r=g","caption":"Harun Spahic"},"sameAs":["http:\/\/human.bsru.ac.th\/"]}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15610"}],"collection":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=15610"}],"version-history":[{"count":1,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15610\/revisions"}],"predecessor-version":[{"id":15617,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/15610\/revisions\/15617"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=15610"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=15610"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=15610"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}