View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Rick Rothstein \(MVP - VB\) Rick Rothstein \(MVP - VB\) is offline
external usenet poster
 
Posts: 2,202
Default 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