Using Network days +1

[spotsteven]

I have to enter a delivery date on sheet... I use the =NOW() +1 to give that.. However weekend and hoilday don't count.. So I would I advoid the weekend/Delivery...date...

IE.. 3/20/2009 would show 3/23/2009 not 3/21/2009

Thanks in advance...
Spotsteven

 

[Domski]

Hi,

If you want to skip holidays and weekends I posted a VBA solution here a bit ago:

http://www.mrexcel.com/forum/showthread.php?t=369417

Hope it helps,

Dom

 

[onlyadrafter]

Hello,

can cover the week-end part using

=IF(WEEKDAY(A2,2)=5,A2+3,A2+1)

not sure how to check for holidays though!

 

[Willem!]

Hi,

Try this:

=IF(NETWORKDAYS(NOW(),NOW()+1)=2,NOW()+1,NOW()+3)

Edit: this only corrects for weekends... not for holidays.... you should go VBA for that one...

 

[barry houdini]

You can use WORKDAY function. It's built in in Excel 2007 but an "Analysis ToolPak" add-in function in earlier versions....., i.e.

=WORKDAY(TODAY(),1,holidays)

where holidays is a named range containing your holidays dates

If you need to install the addin then use

Tools > Add-ins > tick "Analysis ToolPak" > OK