Date Function Question

[mike21mcd]

I need to know how to add a day to a date that I manually enter, excluding weekends. I know I can just do the "+1" to the end of the TODAY() function, but this will not exclude weekends.
For example, if in cell A1 I enter 09/07/2006, I would like for excel to return in cell B1 09/08/2006. If I enter 09/08/2006 in cell A1, I would need 09/11/2006 returned in B1. I have exhausted all "help" topics and cannot figure this one out. Any help would be greatly appreciated. Thanks.

 

[Oaktree]

Welcome to the board.

Have a look at the WORKDAY function, which is part of the Analysis ToolPak Add-in

 

[Andrew Poulsom]

Have a look at the WORKDAY function in Excel Help. It requires that the Analysis ToolPak is installed.

 

[mike21mcd]

Oaktree / Andrew,
Thank you very much for your help. That did the trick. Seems way to simple to have caused such a headache. haha. Thanks again gentlemen!!!