Automating a date calendar to include business days

Hi peeps,

Im not all that bad in excel but i haven't had all that much experience with date functions. I'm trying to automate a calendar such as the one attached to possibly just input the cell of the first working day then it automatically updates iteself. Is this a simple thing to do?

Many thanks
Neill

In cell B3:

Please Login or Register  to view this content.

in cell C2:

Please Login or Register  to view this content.

and copy down

Regards

Try this,
=WORKDAY(E3,1,$K$2:$K$4)

Used in your example

K2:K4 are holidays

Note that use of WORKDAY prior to Excel 2007 requires Activation of the Analysis ToolPak Add-In (Tools -> AddIns)

If you need to deal with public holidays and/or are performing lots of date based calculations it's very worthwhile activating.
Note each client that uses the file will need the same [ie activated on each PC] - you can use VBA to auto activate if necessary.