Excel 2003: Adding weekdays to a Date field?

Question

I have 2 date columns.. A & B. I want to write a formula that will add 3 workdays to column A:

For example, A1 = 2/8/2007
B1 = (a1 + 3 workdays) so it would be 2/12/2007 (not 2/11/07 because that is sunday)

I can't seem to come up with the right formula. Any help is greatly appreciated!

Answer 1

On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

Then use this formula in B1

=WORKDAY(A1,3)

Make sure both A1 and B1 are formated as date fields