Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • INDEX function: Description, Usage, Syntax, Examples and Explanation
  • How to get first row number in range in Excel
  • Approximate match with multiple criteria in Excel
  • Count rows with at least n matching values
  • How to get first column number in range in Excel

Data Analysis Examples

  • Conditional Formatting Icon Sets Examples in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How To Create Pareto Chart in Excel
  • How to create running total in an Excel Table

Data Validation Examples

  • Excel Data validation require unique number
  • Data validation must not exist in list
  • Excel Data validation allow weekday only
  • Excel Data validation unique values only
  • Excel Data validation must begin with

Get project midpoint in Excel

by

To calculate an approximate project midpoint date, you can use the WORKDAY function.

Note: The WORKDAY function returns a date in the future or past, based on a start date, workdays, and optional holidays. WORKDAY automatically excludes weekends, and counts only Monday through Friday as workdays.

Formula

=WORKDAY(start,days/2,holidays)

Explanation

In the example shown, the formula in E5 is:

Worked Example:   Add days exclude certain days of week in Excel
=WORKDAY(C5,E5/2,holidays)

where “holidays” is the named range G5:G10.

The WORKDAY is configured to get a project midpoint date by adding half of the days value to the start date:

=WORKDAY(C5,E5/2,holidays)

Project A is 5 workdays, so E5/2 = 2.5 days. The WORKDAY function ignores fractional values and uses only the integer portion of days, so it uses the value 2 to return a date of May 8.

Worked Example:   Add workdays no weekends in Excel

Note the WORKDAY function does not count the start date as a workday.

Custom schedule

The WORKDAY function always treats Saturday and Sunday as non-working days. To get a midpoint for a project where working days are not Monday-Friday, substitute the WORKDAY.INTL function for WORKDAY. For example, to calculate a midpoint in a project where workdays are Monday-Saturday you can use a formula like this:

=WORKDAY.INTL(start,days/2,11,holidays)

There are many other ways to configure WORKDAY.INTL.

Worked Example:   Get project end date in Excel

Post navigation

Previous Post:

Get project end date in Excel

Next Post:

How to get same date next year or previous year in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to extract word containing specific text in Excel
  • How to extract text between parentheses in Excel
  • How to create email address from name in Excel
  • Normalize text by removing punctuations, extra spaces and more in Excel
  • How to get last word in a cell in Excel
  • Calculate years between dates in Excel
  • WEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • EDATE function: Description, Usage, Syntax, Examples and Explanation
  • Convert text date dd/mm/yy to mm/dd/yy in Excel
  • Steps to create Dynamic calendar grid in Excel
  • Tax rate calculation with fixed base in Excel
  • How to Calculate Tax Rates in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • TBILLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles