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/
 
 
  Click to open user profile  
alexlelee, 12th Jun 2025, 7:37 AM
Coin flipping is said to have originated during the Roman era, where it is referred to as 'navia aut caput' or Ship or head. This is because Roman coins had a ship sketched on one side and a head on the other. In various sports, like cricket, football, and soccer, the initial decision on which side plays first is determined by a Coin Flip https://flipacoin.us.org/. Portland was nearly named Boston because of the coin toss fortune and misfortune. This highlights an example in politics on how important a coin toss can impact a dire decision making.
 
   
 
 
online learning made for people
Dreevoo.com | CONTRIBUTE | FORUM | INFO