Dreevoo.com | Online Learning and Knowledge Sharing
 
Home | Programs | Microsoft Office | Microsoft Excel | Calculate workdays between dates using Excel
Guest
Click to view your profile
Topics
Programs
Languages
Recipes
Home
Shortcuts
 
 

Calculate workdays between dates using Excel

We're going to calculate how many workdays, considering the holidays, are there between two specific dates

 
  Author: mat | Version: 2010 | 24th September 2011 |  
 
 
1.
 

Start the Microsoft Excel and enter the the data just like I did.

 
 
2.
 

Click the cell next to Working days.

 
 
3.
 

In the menu click Formulas.

 
 
4.
 

And click the Insert Function button.

 
 
5.
 

Select All for the category, choose the NETWORKDAYS function and click GO.

 
 
6.
 

In the new window click Start_date field and the click the cell where you have your project start date, click End_date and click the cell with your end date.

 
 
7.
 

Click the Holidays field ...

 
 
8.
 

... and select the cells with holiday entries.

Click OK.

 
 
9.
 

And there's your result. Shouldn't be to hard to finish your project in time ;)

 
 
 
   
  Please login to post a comment
  Click to open user profile  
alexlelee, 21st May 2025, 6:15 PM
PikaShow is a third-party Android-based streaming app that offers users access to thousands of movies, TV shows, live TV channels, and sports events. What makes it unique is its ability to bring together content from multiple OTT platforms like Netflix, Amazon Prime Video, Hotstar, and Zee5—all in one app, without any subscription fees. Whether you’re an Android user, an iPhone user (with a workaround), or someone who watches content on a PC, PikaShow offers you a seamless streaming experience for free. https://pikashowapks.net.in/
 
 
  Click to open user profile  
Zoyashah, 22nd May 2025, 11:45 AM
Lock & Key Doncaster delivers reliability you can count on—just like Excel when used right. Calculate workdays between dates using Excel with the NETWORKDAYS function, which excludes weekends and even holidays if specified. It’s a handy tool for project planning or payroll tracking. Just as a locksmith ensures smooth access and security, mastering Excel functions unlocks efficiency and accuracy in your daily workflow. Simple tools, powerful results—every time. https://doncasterlockandkey.co.uk/
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO