WORKDAY automatically excludes weekends, and counts only Monday through Friday as workdays.

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.

Excel formula: Get project end date

To get a midpoint for a project where working days are not Monday-Friday, substitute theWORKDAY.INTL functionfor WORKDAY.

Unlike the simplerWORKDAY function, WORKDAY.INTL can be…

Excel formula: Get project start date

Excel formula: Add business days to date

Excel formula: Dynamic calendar grid

Excel WORKDAY function

Excel WORKDAY.INTL function