{"id":1340,"date":"2018-07-04T10:31:17","date_gmt":"2018-07-04T10:31:17","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=1340"},"modified":"2023-11-03T14:51:00","modified_gmt":"2023-11-03T14:51:00","slug":"workday","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/functions\/workday\/","title":{"rendered":"WORKDAY function"},"content":{"rendered":"\n

Excel’s WORKDAY function is a useful tool for calculating the date that falls a specified number of workdays before or after a given date. It’s commonly used in business and project management to determine deadlines and project timelines. Let’s break down how this function works in simple terms, suitable for high school students.<\/p>\n\n\n\n

Syntax<\/h2>\n\n\n\n

WORKDAY(start_date, days, [holidays])<\/strong><\/p>\n\n\n\n

Arguments<\/h2>\n\n\n\n

Here are the arguments you can use with the WORKDAY function:<\/p>\n\n\n\n

start_date<\/strong><\/td>The initial date from which you want to calculate workdays.<\/td><\/tr>
days<\/strong><\/td>The number of workdays (positive or negative) you want to add or subtract from the start_date.<\/td><\/tr>
[holidays]<\/strong><\/td>(Optional) An optional list of dates representing holidays when work should not be considered.<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

How to Use<\/h2>\n\n\n\n

Let’s see how to use the WORKDAY function with some examples:<\/p>\n\n\n\n

Example 1:<\/strong> Calculate a date 5 workdays after July 1, 2023:<\/p>\n\n\n\n

=WORKDAY(\"2023-07-01\", 5)<\/code><\/pre>\n\n\n\n
This formula will return the date July 8, 2023, because it skips the weekend (Saturday and Sunday).<\/p>\n\n\n\n
Example 2:<\/strong> Calculate a date 10 workdays before November 15, 2023, considering Thanksgiving as a holiday:<\/p>\n\n\n\n
=WORKDAY(\"2023-11-15\", -10, {\"2023-11-23\"})<\/code><\/pre>\n\n\n\n
In this case, the formula will return November 3, 2023, as it accounts for Thanksgiving (November 23) as a holiday and counts back 10 workdays.<\/p>\n\n\n\n
Example 3:<\/strong> Calculate a date 3 workdays after December 25, 2023, considering Christmas and New Year’s Day as holidays:<\/p>\n\n\n\n
=WORKDAY(\"2023-12-25\", 3, {\"2023-12-25\", \"2024-01-01\"})<\/code><\/pre>\n\n\n\n
The result will be December 29, 2023, since Christmas and New Year’s Day are considered holidays, and it skips them.<\/p>\n\n\n\n
Remember that the WORKDAY function is incredibly useful when you need to handle business days or workdays in your date calculations, taking holidays into account.<\/p>\n\n\n\n
Additional Information<\/h2>\n\n\n\n
If you encounter terms or concepts you’re unfamiliar with, you can look up their definitions on relevant websites or dictionaries for a more comprehensive understanding.<\/p>\n","protected":false},"excerpt":{"rendered":"
Excel’s WORKDAY function is a useful tool for calculating the date that falls a specified number of workdays before or after a given…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[25],"tags":[180],"yoast_head":"\nWORKDAY function<\/title>\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\/functions\/workday\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WORKDAY function\" \/>\n<meta property=\"og:description\" content=\"Excel’s WORKDAY function is a useful tool for calculating the date that falls a specified number of workdays before or after a given...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/officetuts.net\/excel\/functions\/workday\/\" \/>\n<meta property=\"article:published_time\" content=\"2018-07-04T10:31:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-03T14:51:00+00:00\" \/>\n<meta name=\"author\" content=\"Tomasz Decker\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tomasz Decker\" \/>\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\":\"Article\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/\"},\"author\":{\"name\":\"Tomasz Decker\",\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"headline\":\"WORKDAY function\",\"datePublished\":\"2018-07-04T10:31:17+00:00\",\"dateModified\":\"2023-11-03T14:51:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/\"},\"wordCount\":279,\"publisher\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42\"},\"keywords\":[\"done\"],\"articleSection\":[\"functions\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/\",\"url\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/\",\"name\":\"WORKDAY function\",\"isPartOf\":{\"@id\":\"https:\/\/officetuts.net\/excel\/#website\"},\"datePublished\":\"2018-07-04T10:31:17+00:00\",\"dateModified\":\"2023-11-03T14:51:00+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/officetuts.net\/excel\/functions\/workday\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/officetuts.net\/excel\/functions\/workday\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/officetuts.net\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WORKDAY function\"}]},{\"@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.\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WORKDAY function","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\/functions\/workday\/","og_locale":"en_US","og_type":"article","og_title":"WORKDAY function","og_description":"Excel’s WORKDAY function is a useful tool for calculating the date that falls a specified number of workdays before or after a given...","og_url":"https:\/\/officetuts.net\/excel\/functions\/workday\/","article_published_time":"2018-07-04T10:31:17+00:00","article_modified_time":"2023-11-03T14:51:00+00:00","author":"Tomasz Decker","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tomasz Decker","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/#article","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/"},"author":{"name":"Tomasz Decker","@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"headline":"WORKDAY function","datePublished":"2018-07-04T10:31:17+00:00","dateModified":"2023-11-03T14:51:00+00:00","mainEntityOfPage":{"@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/"},"wordCount":279,"publisher":{"@id":"https:\/\/officetuts.net\/excel\/#\/schema\/person\/41b0b6996aaa4c4127f86f3d24452d42"},"keywords":["done"],"articleSection":["functions"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/","url":"https:\/\/officetuts.net\/excel\/functions\/workday\/","name":"WORKDAY function","isPartOf":{"@id":"https:\/\/officetuts.net\/excel\/#website"},"datePublished":"2018-07-04T10:31:17+00:00","dateModified":"2023-11-03T14:51:00+00:00","breadcrumb":{"@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/officetuts.net\/excel\/functions\/workday\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/officetuts.net\/excel\/functions\/workday\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/officetuts.net\/excel\/"},{"@type":"ListItem","position":2,"name":"WORKDAY function"}]},{"@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."}]}},"_links":{"self":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1340"}],"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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/comments?post=1340"}],"version-history":[{"count":3,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1340\/revisions"}],"predecessor-version":[{"id":16610,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/posts\/1340\/revisions\/16610"}],"wp:attachment":[{"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/media?parent=1340"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/categories?post=1340"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/officetuts.net\/excel\/wp-json\/wp\/v2\/tags?post=1340"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}