I want my calculated date to exclude Sat and Sun

[Benetta]

I have entered a date in a cell, B1, ex. 2/5/04.
In the next cell, I added 3 days, =B1 + 3, the results shown is 02/08/04
I want the results to show the next working day, in this case, I want the result to be 02/09/04.

 

[Aladin Akyurek]

=WORKDAY(B1,3)

This requires taht the Analysis Toolpak add-in is activated.

I have entered a date in a cell, B1, ex. 2/5/04.
In the next cell, I added 3 days, =B1 + 3, the results shown is 02/08/04.
I want the results to show the next working day, in this case, I want the

result to be 02/09/04.

 

[Chip Pearson]

Benetta,

See the WORKDAY function. E.g.,

=WORKDAY(B1,3)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

I have entered a date in a cell, B1, ex. 2/5/04.
In the next cell, I added 3 days, =B1 + 3, the results shown is 02/08/04.
I want the results to show the next working day, in this case,

I want the result to be 02/09/04.