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