Manuals/calci/WORKDAY
Jump to navigation
Jump to search
WORKDAY(SD, days, holidays)
where,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SD} represents the starting date,
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle days} represents the number of nonweekend and nonholiday days before or after start date, and
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle holidays} is an optional list of one or more dates to exclude from the working days.
WORKDAY() displays the working day before or after the mentioned number of days from the starting date, excluding the weekend days and holidays.
Description
WORKDAY(SD, days, holidays)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle SD} and should be entered either in 'date format' or 'dates returned using formulas'.
- If date values are invalid, Calci displays #N/A error message.
- Argument Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle days} can be positive or negative.
- For positive days, Calci calculates working day after the mentioned number of days from starting date. For negative days, Calci calculates the working day before the mentioned days before starting date.
should be entered either in 'date format' or 'dates returned using formulas'.Examples
Consider the following example that shows the use of WORKDAY function:
| 6/1/2014 | 3/1/2014 | |
| 140 | -30 | |
| 8/4/2014 | ||
| 9/30/2014 |
=WORKDAY(A1,A2): Calculates next working day 140 days after date mentioned in A1. Weekend days are excluded. Displays 12/12/2014 as a result. =WORKDAY(A1,A2,A3:A4):Calculates next working day 140 days after date mentioned in A1 and holidays in A3, A4. Weekend days are excluded. Displays 12/16/2014 as a result. =WORKDAY(B1,B2) : Calculates working day 30 days before the starting date mentioned in B1. Displays 01/20/2014 as a result. =WORKDAY(DATE(2013,6,1),60): Calculates next working day 60 days after mentioned date. Displays 8/23/2013 as a result.