Returns a date that is the indicated number of working days before or after a start date.
ฟังก์ชันนี้ทำงานใน Google Sheets เหมือนกับใน Excel — ไวยากรณ์และอาร์กิวเมนต์เดียวกัน
WORKDAY(start_date, days, [holidays])The WORKDAY function calculates a future or past date by excluding weekends and optional holidays. It is commonly used for project scheduling and calculating delivery deadlines that must fall on business days.
=WORKDAY("2023-10-01", 5)ผลลัพธ์: 2023-10-06
Calculates the date 5 working days after October 1, 2023, skipping the weekend.
No, the function starts counting from the day after the start_date provided.