When you're trying to determine how many days you have left before reaching a project deadline, try this handy Excel technique.

By Mary Richardson in Microsoft Office , July 7, , 5: You don't need to count out days on a calendar to find out how many days you have to complete a project. To set up a worksheet that will calculate the number of working days excluding weekends and holidays from a project's start date to its due date, follow these steps:. Check out the Microsoft Excel archive and catch up on other Excel tips.

Count the Days between Two Dates in Excel

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday. Cyberweapons are now in play: From US sabotage of a North Korean missile test to hacked emergency sirens in Dallas. Elon Musk and the cult of Tesla: How a tech startup rattled the auto industry to its core.

The truth about MooCs and bootcamps: Their biggest benefit isn't creating more coders. How Mark Shuttleworth became the first African in space and launched a software revolution. We deliver the top business tech news stories about the companies, the people, and the products revolutionizing the planet.

Calculate Workdays Between Two Dates

Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and tips. Defenses, response plans, and greatest concerns about cybersecurity in an IoT and mobile world.

To set up a worksheet that will calculate the number of working days excluding weekends and holidays from a project's start date to its due date, follow these steps: Enter the headings for Project, Start Date, End Date, and Work Days as shown.

Right-click the selection and choose Format Cells. Right-click the selection and choose Format cells.

Select Date under Category and Mar under Type. Complete the Holiday Table as shown. LOG IN TO COMMENT. My Profile Log Out. Free Newsletters, In your Inbox.

Tech News You Can Use We deliver the top business tech news stories about the companies, the people, and the products revolutionizing the planet. Delivered Daily Subscribe Best of the Week Our editors highlight the TechRepublic articles, galleries, and videos that you absolutely cannot miss to stay current on the latest IT news, innovations, and tips.

How to count the number of days / workdays / weekends between two dates in Excel?

Latest From Tech Pro Research. Privacy Policy Cookies Ad Choice Terms of Use Mobile User Agreement. A ZDNet site Visit other CBS Interactive sites: Select Site CBS Cares CBS Films CBS Radio CBS.