Returns the serial number of the date before or after a specified number of workdays with custom weekend parameters.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
WORKDAY.INTL(start_date, days, [weekend], [holidays])The WORKDAY.INTL function calculates a future or past date by excluding weekends and specified holidays. Unlike the standard WORKDAY function, it allows you to define which days of the week are considered weekends using a string or index number.
=WORKDAY.INTL("2023-01-01", 5, 1)ผลลัพธ์: 2023-01-09
Calculates the date 5 workdays after Jan 1, 2023, treating Saturday and Sunday as weekends.
Use the 'weekend' argument with a specific code (e.g., 11 for Sunday only) or a string (e.g., '0000011' for Friday and Saturday).