Formula to Display Date n-Workdays from a Certain Date
Thank you, that worked. Can you give me an example of a holiday list?
From the Help files for WORKDAY...
"....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."
Rick
|