In this video I cover 2 functions…WORKDAY and WORKDAY.INTL. Both are used to calculate the date that is a given number of working days from another date. The WORKDAY function defines a working day as Monday through Friday. The WORKDAY.INTL function let’s YOU define what are workdays and what are weekends.
The formulas that I used in the demos:
=WORKDAY(A2,7)
=WORKDAY(A2,7,I1:I12)
=WORKDAY.INTL(A2,7,11)
Download a copy of the file(s) used in this video: https://share.zight.com/rRux75pz