How To › Software Count Days Between Two Dates in Excel Functions to Count Days Between Two Dates in Excel Share Pin Email Print Software Spreadsheets Documents Presentations Desktop Publishing Graphic Design Databases Animation & Video by Ted French Updated March 06, 2017 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 NETWORKDAYS Function Excel Date Function Tutorials. Excel 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. Excel NETWORKDAYS.INTL Function Excel Date Function Tutorials. Excel Date Function Tutorials Similar to the NETWORKDAYS function above, except that the NETWORKDAYS.INTL function can be used for those locations where the weekend days do not fall on Saturday and Sunday. Single day weekends are accommodated as well. This function first became available in Excel 2010. Excel DATEDIF Function Excel Date Function Tutorials. Excel 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. Excel WORKDAY Function Excel Date Function Tutorials. Excel 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. Excel WORKDAY.INTL Function Excel Date Function Tutorials. Excel Date Function Tutorials Similar to Excel's WORKDAY function above, except that the WORKDAY.INTL function can be used for those locations where the weekend days do not fall on Saturday and Sunday. Single day weekends are accommodated as well. This function first became available in Excel 2010. Excel EDATE Function Excel Date Function Tutorials. Excel 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. Excel EOMONTH Function Excel Date Function Tutorials. Excel Date Function Tutorials The EOMONTH function, short for End of Month function can be used to calculate a due date of a project or investment that falls at the end of the month. Excel DAYS360 Function Excel Date Function Tutorials. Excel Date Function Tutorials The Excel 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. Convert Dates with DATEVALUE Converting Text Data into Dates with DATEVALUE. © Ted French he DATEVALUE function can be used to convert a date that has been stored as text into a value that Excel recognizes. This might be done if data in a worksheet is to be filtered or sorted by date values or the dates are to be used calculations - such as when using the NETWORKDAYS or WORKDAY functions. Continue Reading