Date Function to exclude Weekends and display as dates

[petes]

I need a function so that it will calculate as follows:

A1 = I will enter the date
B1 = I will enter the number
C1 = RESULT (Formula needed???)

Calculation of RESULT

Eg: If i enter the date as 05/09/2011 in cell A1 and enter 5 in cell B1, the result should add 5 to 05/09/2011, but should exclude the weekends (Sat and Sun) and display the date in C1

In this example it should display 05/16/2011 in cell C1 and NOT 05/14/2011 (Because 05/14/2011 is a weekend)

 

[JamesW]

Hi,

Try: =workday(A1,B1)

Ensure you have the Analysis ToolPak enabled: Tools -> Addins -> Analysis ToolPak

 

[petes]

Thank you very much.... that was really quick

 

[Roj47]

Unfortunately I am unable to active the toolpak to validate what I am writing, so bear with me.

Try also,

=networkdays(a1, b1, f1:f11)

If you place bank holidays, booked holidays etc... in, then these will take the role of being counted as weekends.

Regards