1.0Xelplus - Leila Gharanihttps://www.xelplus.comLeila Gharanihttps://www.xelplus.com/author/xelplus/Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidaysrich600338<blockquote class="wp-embedded-content" data-secret="dyB4ScotY7"><a href="https://www.xelplus.com/excel-workday-function/">Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.xelplus.com/excel-workday-function/embed/#?secret=dyB4ScotY7" width="600" height="338" title="“Excel WORKDAY & NETWORKDAYS Functions: Exclude Weekends and Holidays” — Xelplus - Leila Gharani" data-secret="dyB4ScotY7" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script>
/*! This file is auto-generated */
!function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document);
</script>
https://www.xelplus.com/wp-content/uploads/2017/06/Workday-Function.gif800450Find out the difference between the WORKDAY and NETWORKDAYS functions. You can use them to calculate the end date based on the number of allocated working days or calculate the number of working days you have before a deadline. Both are useful for creating project timelines and reporting timetables.