writer
6,694
edits
Changes
Jump to navigation
Jump to search
Line 1:
Line 1: − + − + Line 10:
Line 10: − + − +
no edit summary
=WORKDAY(SD, days, holidays)=
<div style="font-size:30px">'''WORKDAY (start_date,days,holidays)'''</div><br/>
where,
where,
*<math>SD</math> represents the starting date,
*<math>start-date</math> represents the starting date,
*<math>days</math> represents the number of nonweekend and nonholiday days before or after the starting date, and
*<math>days</math> represents the number of nonweekend and nonholiday days before or after the starting date, and
*<math>holidays</math> is an optional list of one or more dates to exclude from the working days.
*<math>holidays</math> is an optional list of one or more dates to exclude from the working days.
== Description ==
== Description ==
WORKDAY(SD, days, holidays)
WORKDAY(start_date, days, holidays)
*<math>SD</math> and <math>holidays</math> should be entered either in 'date format' or 'dates returned using formulas'.
*<math>start-date</math> and <math>holidays</math> should be entered either in 'date format' or 'dates returned using formulas'.
*If date values are invalid, Calci displays #N/A error message.
*If date values are invalid, Calci displays #N/A error message.
*Argument <math>days</math> can be positive or negative.
*Argument <math>days</math> can be positive or negative.