I want my calculated date to exclude Sat and Sun

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=WORKDAY(B1,3)

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

Benetta said:
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
Click to expand...
result to be 02/09/04.
 
Benetta,

See the WORKDAY function. E.g.,

=WORKDAY(B1,3)


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


Benetta said:
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,
Click to expand...
I want the result to be 02/09/04.
 
Back
Top