How can we help?
WORKDAY.INTL(DATE(1969, 7, 21), 4, 1, A1:A10)
WORKDAY.INTL(DATE(1995, 8, 13), -2, 2, B1:B10)
WORKDAY.INTL(DATE(1969, 7, 21), 0)
WORKDAY.INTL(start_date, num_days, [weekend], [holidays])
start_date- The date from which to begin counting.
num_days- The number of working days to advance from start_date. If negative, counts backwards.
weekend- [ OPTIONAL -
1by default ] - A number or string representing which days of the week are considered weekends.
holidays- [ OPTIONAL ] - A range or array constant containing the dates to consider holidays.
WORKDAY.INTL does not auto-convert number formats in the same way that Excellentable does upon direct entry into cells. Therefore,
WORKDAY.INTL(10/10/2000,4) is interpreted as
WORKDAY.INTL(0.005,4), where the provided date is the quotient of 10 divided by 10 divided by 2000.
WORKDAY.INTL calculates a number of working days after a given date. To calculate the number of working days between two dates, use
WORKDAY.INTLworks similarly to
WORKDAYbut also allows weekend days to be specified (for areas where Saturday and Sunday are not considered the weekend).
WORKDAY: Calculates the number of working days from a specified start date.
NETWORKDAYS.INTL: Returns the number of net working days between two provided days excluding specified weekend days and holidays.
EDATE: Returns a date a specified number of months before or after another date.
EOMONTH: Returns a date representing the last day of a month which falls a specified number of months before or after another date.
NOW: Returns the current date and time as a date value.