Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Dates formula in Excel - I have attached an image that asks my question.

enter image description here

share|improve this question
    
The NETWORKDAYS function may be of some use here, but I fear it may be an iterative process for all but the smallest values in column C. – James May 5 '11 at 15:59
up vote 5 down vote accepted

The formula is:

=WORKDAY(D7,C7,[Optional list of Holidays])

which you put in D8 and then drag down.
Your cells have to be in a Date format. The help file says for the Holidays list:

  • Holidays Optional. 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.

Note that in your example, there is no holiday between 2/22/2011 and 2/24/2011, so D17 should be 2/24/2011, and the others modified from there. Also D20 is not 10 days from 2/28/2011.

share|improve this answer
    
Thanks, how would I exclude holidays if there were in the list? Would I have to make a seperate list of holiday dates and include it in the WORKDAY formula? – Mike May 5 '11 at 16:13
    
@Mike, You can add a list of holidays as a third parameter, see the help files. I'll edit my answer. – Lance Roberts May 5 '11 at 16:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .