Dear someone disana,
Saya juga newbie nih, baru kali ini perhatiin fungsi workday. Jadi saya tidak
sungkan2 tanya ke fitur help-nya excel, dan ternyata di penjelasannya saya rasa
jawabannya sangat jelas (dibawah dengan hijau).
WORKDAY(start_date,days,holidays)
Start_date is a date that represents the start date.
Days is the number of nonweekend and nonholiday days before or
after start_date. A positive value for days yields a future date; a negative
value yields a past date.
Holidays is an optional list of one or more dates to exclude from
the working calendar, such as state and federal holidays and floating holidays.
The list can be either a range of cells that contain the dates or an array
constant (array: Used to build single formulas that produce multiple results or
that operate on a group of arguments that are arranged in rows and columns. An
array range shares a common formula; an array constant is a group of constants
used as an argument.) of the serial numbers that represent the dates.
blessings,
tomz
----- Original Message -----
From: ppic.pkm
To: [email protected]
Sent: Tuesday, May 04, 2010 10:12 AM
Subject: ]] XL-mania [[ hitung mundur tanggal
Para Pakar Excel yang mengagumkan cara berpikir dan kerjanya,
Bagaimana menghitung kapan harus dimulai proses awalnya, jika telah
ditentukan tanggal selesainya (backward)?
Terima kasih.
