Service mondial
![Phone Light Blue.png](https://static.wixstatic.com/media/16e582_94dfe0a4c5e74623aa8a22be6f1f7346~mv2.png/v1/fill/w_15,h_18,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Phone%20Light%20Blue.png)
ou
Votre partenaire dans la formation aux logiciels et le développement d'application
depuis plus de 25 ans
Microsoft Excel articles et conseils
![Excel Icon.png](https://static.wixstatic.com/media/16e582_ab17fd548a714b8ea068b952b0e1784b~mv2.png/v1/fill/w_73,h_68,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Excel%20Icon.png)
© 2009 DJH Training & Application Solutions Inc - Updated 2022
QUESTION: How can I figure out the number of work days, excluding holidays and weekends, between two dates?​
​
ANSWER: Use the NETWORKDAYS function. The components of this function are start date, end date, holidays (optional). The WORKDAY function is also useful to calculate a due date based on a start date, number of days, holidays (optional).
​
​If you would like to include statutory holidays, create a table that lists them first (we named this partial example tblHolidays). The Holiday column is added for clarity and is optional.
![Networkdays 1.png](https://static.wixstatic.com/media/16e582_2845c7c749e84f41b228f8c0a0fd1073~mv2.png/v1/fill/w_257,h_136,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Networkdays%201.png)
Here is an example of using the NETWORKDAYS function, using this formula:
=NETWORKDAYS(B2,C2,tblHolidays[Date])
![Networkdays 2.png](https://static.wixstatic.com/media/16e582_993ca1f1871f4e86b71ad3288509a433~mv2.png/v1/fill/w_596,h_73,al_c,q_85,usm_0.66_1.00_0.01,enc_auto/Networkdays%202.png)
Here is an example of using the WORKDAY function, using this formula:
=WORKDAY(B2,C2,tblHolidays[Date])
![Networkdays 3.png](https://static.wixstatic.com/media/16e582_2b1bb6adefcf4692b6b4a9ba83ae1972~mv2.png/v1/fill/w_56,h_6,al_c,q_85,usm_0.66_1.00_0.01,blur_2,enc_auto/Networkdays%203.png)