The WORKDAY function is ideal for calculating a set number of days forward (or backward) in time but skip the weekends and possibly holidays. There are two versions of the WORKDAY function:
- WORKDAY – Older version that defines Saturday and Sunday as weekends.
- INTL – Updated version that allows for the definition of 1 or 2-day weekends and what day they occur.
As the WORKDAY.INTL is more feature-rich, we’ll demonstrate that version. We define the arguments as follows:
- Day to calculate from
- Number of days to count forward or backward
- The desired weekend combination
- The list of holidays (if needed)
If we have a date in cell A3 and we wish to count 21 days into the future, avoiding weekends (Saturday and Sunday) and any holidays that listed (range F3:F15), the formula would be written as:
=WORKDAY.INTL(A3, 21, 1, $F$3:$F$15)
The codes for the weekends are as follows:
To learn more about the WORKDAY and NETWORKDAY functions, check out the link below.
ليست هناك تعليقات:
إرسال تعليق