ID EN
…
#Date and time

WORKDAY.INTL

Excel Functions 🇮🇩 Bahasa Indonesia

Dapatkan tanggal dan hari kerja di masa depan atau masa lalu

Syntax

EXCEL 
=WORKDAY.INTL(start_date, days, [weekend], [holidays])

Arguments

Parameter Deskripsi
start_date The start date.
days Working days before or after start date.
weekend [optional] Setting for non-working days.
holidays [optional] A list of dates that are non-working days.

Return Value

Nomor seri yang mewakili tanggal di Excel.

Details

Fungsi WORKDAY.INTL menghitung tanggal di masa depan atau masa lalu yang merupakan jumlah hari kerja tertentu dari tanggal mulai yang ditentukan, tidak termasuk akhir pekan dan (opsional) hari libur. Anda dapat WORKDAY.INTL untuk menghitung tanggal mulai proyek, tanggal pengiriman, dan tanggal penyelesaian yang harus mengabaikan hari non-kerja. Fungsi WORKDAY.INTL lebih tangguh dibandingkan fungsi WORKDAY yang lebih sederhana karena hari akhir pekan dapat disesuaikan sehingga setiap hari dalam seminggu dapat menjadi hari kerja atau non-hari kerja. Perhatikan bahwa WORKDAY.INTL secara otomatis akan mengecualikan hari Sabtu dan Minggu tetapi hanya akan mengecualikan hari libur jika disediakan. Fungsi WORKDAY.INTL membutuhkan empat argumen: Untuk mengilustrasikan cara kerja WORKDAY.INTL, asumsikan kita menjadwalkan tugas yang memakan waktu 5 hari kerja, dimulai pada hari Senin, 1 Juli 2024. Tujuannya adalah untuk

Contoh

The WORKDAY.INTL function explained

To illustrate how WORKDAY.INTL works, assume we are scheduling a task that takes 5 working days, starting on Monday, July 1, 2024. The goal is to calc

EXCEL 
="1-Jul-2024"+5 // returns "6-Jul-2024"
The WORKDAY.INTL function explained

The result is Saturday, July 6, 2024. While this is a valid result, it doesn't take into account that Saturday is probably not a working day. If, on t

EXCEL 
=WORKDAY.INTL("1-Jul-2024",5) // returns "8-Jul-2024"
The WORKDAY.INTL function explained

The result is Monday, July 8, 2024. This is because WORKDAY.INTL automatically skips Saturdays and Sundays when it calculates a result. Taking things

EXCEL 
=WORKDAY.INTL("1-Jul-2024",5,"0000111") // returns "9-Jul-2024"
The WORKDAY.INTL function explained

The result is now Tuesday, July 9. The text string "0000111" means Mondays, Tuesdays, Wednesdays, and Thursdays are workdays, and Fridays, Saturdays,

EXCEL 
=WORKDAY.INTL("1-Jul-2024",5,"0000111",{"4-Jul-2024";"2-Sep-2024"}) // returns "10-Jul-2024"
The WORKDAY.INTL function explained

The formula in D5 does not use WORKDAY.INTL and simply adds 5 days to the start date:

EXCEL 
=B5+C5 // returns "6-Jul-2024"
The WORKDAY.INTL function explained

The formula in D6 uses the WORKDAY.INTL function but does not provide any holidays:

EXCEL 
=WORKDAY.INTL(B6,C6)// returns "8-Jul-2024"

See Also

WORKDAY NETWORKDAYS NETWORKDAYS.INTL