Explanation
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.
In the example shown, 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.
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. This page provides details.
Related formulas
Get project end date
Get project start date
Add workdays to date custom weekends
Add business days to date
Dynamic calendar grid
Related functions
WORKDAY Function
The Excel WORKDAY function takes a date and returns the nearest working day n days in the future or past. You can use the WORKDAY function to calculate things like ship dates, delivery dates, and completion dates that need to take into account working and non-working days.
WORKDAY.INTL Function
The Excel WORKDAY.INTL function takes a date and returns the "next" working day, based on a given offset value. Unlike the WORKDAY function, WORKDAY.INTL allows you to customize which days are considered weekends (non-working days). You can use...
