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.