1. Home
  2. Computing & Technology
  3. Spreadsheets

Count Days Between Two Dates in Excel 2007
Functions to Count Days Between Two Dates in Excel

By , About.com Guide

Listed here are Excel functions that can be used to count the number of business days between two dates or find the start and end dates of a project given a set number of business days. These functions can be very useful for planning and when writing proposals to determine the time frame of a project. Several of the functions will automatically removes weekend days from the total. Specific holidays can be omitted as well.

Excel 2007 NETWORKDAYS Function

Excel Date Function TutorialsExcel Date Function Tutorials
The NETWORKDAYS function can be used to calculate the number of business days between the start date and end date of a project. This tutorial includes an example of calculating the number of business days between two dates using the NETWORKDAYS function in Excel 2007.

Excel 2007 EDATE Function

Excel Date Function TutorialsExcel Date Function Tutorials
The EDATE function can be used to calculate a due date of a project or investment that fall on the same day of the month as the date it was issued.This tutorial includes an example of calculating the due date of a project using the EDATE function in Excel 2007.

Excel 2007 WORKDAY Function

Excel Date Function TutorialsExcel Date Function Tutorials
The WORKDAY function can be used to calculate the end date or start date of a project for a given number of business days. This tutorial includes an example of calculating the end date of a project using the WORKDAY function in Excel 2007.

Excel 2007 DAYS360 Function

Excel Date Function TutorialsExcel Date Function Tutorials
The Excel 2007 DAYS360 Function can be used in accounting systems to calculate the number of days between two dates based on a 360-day year (twelve 30-day months). This tutorial includes an example that calculates the number of days between two dates using the DAYS360 function.

Excel DATEDIF Function

Excel Date Function TutorialsExcel Date Function Tutorials
The DATEDIF function can be used to calculate the number of days between dates. This tutorial includes a step by step example of using the DATEDIF function in Excel.
Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Days Between Dates in Excel - Count Days Between Two Dates in Excel>

©2009 About.com, a part of The New York Times Company.

All rights reserved.