mike21mcd
Board Regular
- Joined
- Sep 6, 2006
- Messages
- 67
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.
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.