Date projections

I need a formula to project a date based on number of workdays. Example: Today (9/7/2010) + 21 workdays=10/6/2010. I am looking for the formula that return the 10/6/2010 answer. Thanks.

You need to do nothing for this:
Assume you have dates in Column A, set both the columns (A,B and also the result Column C formats as Date):

    A          B  
Date       Days to add
6/9/2007       3
=TODAY()       5
12/10/2008     54

Copy the below formula in column C then the result will be automatically shown in Column C:

Formula	Description (Result)
=A2+B2	Add 3 days to 6/9/2007 (6/12/2007)
=A3+B3	Add 5 days to the current day (varies)
=A4+B4	Add 54 days to 12/10/2008 (2/2/2009)

Thanks

I understand your answer; however, my calculation should include weekdays only--not weekends. So that if I need to add 4 weekdays (workdays) to 9/7/2010, the answer I am looking for would be Monday, 9/13/2010 not  Saturday 9/11/2010.

I am still getting weekends in the calculations--see below.

Start	Add	End
9/7/2010	4	9/11/2010
9/7/2010	5	9/12/2010

Note that 9/11 is a Saturday and 9/12 is a Sunday.

I was expecting the first calculation to return 9/13/2010 (Monday) and the second calculation to return 9/14/2010 (Tuesday).