Home » Posts

Next business day 6 months in future

To get a date 6 months in the future, on the next work day, you can use a formula based on the WORKDAY function, with help from EDATE. In the example shown, the formula in C6 is =WORKDAY(EDATE(B6,6)-1,1,B9:B11)

April 14, 2025 · 1 min · 65 words · Sean Mitchell

Table of Contents

Explanation

Working from the inside out, EDATE first calculates a date 6 months in the future.

In the example shown, that date is December 24, 2015.

WORKDAY then calculates the next business day one day in the future, taking into account holidays and weekends.

Excel formula: Date is workday

If you need more flexibility with weekends, it’s possible for you to use WORKDAY.INTL.

Unlike the simplerWORKDAY function, WORKDAY.INTL can be…

Excel formula: Calculate retirement date

Excel WORKDAY function

Excel WORKDAY.INTL function

Explanation#

Explanation