Instead of listing all holidays in the parens, I tried, per instructions,
listing them in individual cells, and selecting those cells, eg,
!HolidayA1:A11 The big problem is I have a long column of dates where I want
to use the WORKDAY function, but when I copy and paste the formula, or drag
it, all the way down, the A1:A:11 becomes A2:A12 in the next row, etc. I
even tried using a $ in front of the A1 and A11 but it didn't help. Help!
"William Horton" wrote:
I don't totally understand your question / scenario but both the NETWORKDAYS
and WORKDAY functions exclude weekends. They also both have optional
arguments for you to enter a range that has your companies holiday dates in
them. This should get you what you want.
WORKDAY(1/1/05, 5, 1/3/05) will return 1/10/05 because 1/1 and 1/2 are a
weekend and 1/3 is listed as a holiday. 5 working days from 1/1 = 1/10.
NETWORKDAYS(1/1/05, 1/10/05, 1/3/05) will return 5 because 1/1, 1/2, 1/8,
and 1/9 are weekends and because 1/3 is listed as a holiday. 5 working days
between the 2 dates.
Hope this helps.
Thanks,
Bill Horton
"chaminod" wrote:
A couple of great people here helped me with a minor prob I had on this
one & then my boss threw something else into the mix that has me
stumped:
The scenario below works great, but the end date appears 3 months late
because it includes holidays & weekends.
I thought NETWORKDAYS would help, but I think I am mistaken. I have a
schedule of holiday dates through year 2010 off to the side in cells
N8-S18 that a workable formula could refer to.
Any suggestions will be duly praised and appreciated!
........C...................D..................... ......E.........
1......1............10/25/2005...........10/26/2005
2......2............10/27/2005...........10/29/2005
3......0............10/29/2005...........10/29/2005
4......3............10/29/2005...........11/01/2005
Column C is the duration of the project in days. Column D is the
project start date. Column E is the project end date.
As example, in D4 I'm using the formula =IF(C3=0,E3+0,E3+1). I need to
include something to make it ignore weekends & holidays.
I don't have much experience in multiple conditions - I tried some
things & made a decent mess of it.
--
chaminod
------------------------------------------------------------------------
chaminod's Profile: http://www.excelforum.com/member.php...o&userid=18163
View this thread: http://www.excelforum.com/showthread...hreadid=493488