Tell me more ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.
up vote 1 down vote favorite

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

1 Answer

up vote 4 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.