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

Lookup and Reference Examples

  • Lookup entire row in Excel
  • Extract data with helper column in Excel
  • How to use Excel MATCH Function
  • How to get relative column numbers in a range in Excel
  • Last row number in range

Data Analysis Examples

  • Understanding Pivot Tables in Excel
  • Get column name from index in Excel Table
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Excel Frequency Function Example
  • Conflicting Multiple Conditional Formatting Rules in Excel

Data Validation Examples

  • Excel Data validation with conditional list
  • Excel Data validation date in specific year
  • Prevent invalid data entering in specific cells
  • Excel Data validation date in next 30 days
  • Excel Data validation exists in list

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:

=WORKDAY(C5,E5/2,holidays)

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

Worked Example:   Get last working day in month in Excel

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:   How to calculate project start date based on end date 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.

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
  • NUMBERVALUE function: Description, Usage, Syntax, Examples and Explanation
  • How to create email address from name in Excel
  • How to extract substring in Excel
  • Remove text by position in a cell in Excel
  • Find function vs Search function in Excel
  • Get days between dates ignoring years in Excel
  • Basic Overtime Calculation Formula in Excel
  • Display Date is same month in Excel
  • How to determine year is a leap year in Excel
  • Excel Date & Time Functions Example
  • NOMINAL function: Description, Usage, Syntax, Examples and Explanation
  • PMT, RATE, NPER, PV and FV Financial Functions in Excel
  • DB function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate simple interest in Excel
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
© 2022 xlsoffice . All Right Reserved. | Teal Smiles