# Difference between revisions of "Documentation/How Tos/Calc: WORKDAY function"

From Apache OpenOffice Wiki

< Documentation | How Tos

OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
OOoWikiBot (Talk | contribs) m (Robot: Automated text replacement %s) |
||

Line 21: | Line 21: | ||

{{Documentation/SeeAlso| | {{Documentation/SeeAlso| | ||

* [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]] | * [[Documentation/How_Tos/Calc: NETWORKDAYS function|NETWORKDAYS]] | ||

− | * [[Documentation/How_Tos/Calc: EDATE function|EDATE]] | + | * [[Documentation/How_Tos/Calc: EDATE function|EDATE]] |

− | * [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]] | + | * [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]] |

− | * [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]] | + | * [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]] |

* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | * [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]] | ||

* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} | * [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}} |

## Revision as of 14:47, 26 February 2009

## WORKDAY

Returns a date a given number of workdays away.

This function is only available if the **Analysis AddIn** is installed.

### Syntax:

**WORKDAY(startdate; days; hols_range)**

- returns the date that is
workdays after the given date**days**.**startdate** -
is a number (which may be negative to find a date before**days**).**startdate** - Saturday and Sunday are assumed to be non-working days.
(optional) is a range containing dates of other non-working days.**hols_range**

### Example:

**WORKDAY("2008-09-05"; 1)**

- returns the date-time serial number for Monday 8Sep08. 5Sep08 is a Friday.

**WORKDAY("2008-09-05"; 1; D1:D2)**

- where D1 contains 8Sep08 and D2 contains 25Dec08, returns the date-time serial number for 9Sep08. The 8Sep08 is specified as a holiday.