Formula for adding only workdays

J

JoAnn

I need to have a date column that contains a date that is 3 workdays from the
date specified in another column ("date submitted").

Right now it's set to give me 3 days from the date in the submission column
but I need to have it skip weekend dates in its calculation.

Is there a way to do that?
 
G

Gord Dibben

See help on WORKDAY function.

Note: you must load the Analysis ToolPak to make that function available.


Gord Dibben MS Excel MVP
 
J

JoAnn

Many thanks ... that works great!

--
JoAnn


Gord Dibben said:
See help on WORKDAY function.

Note: you must load the Analysis ToolPak to make that function available.


Gord Dibben MS Excel MVP
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date calculation question 3
Looking for a way to Force Successor Task to next workday IF 'x' amount of time left in workday 0
Add no. of days to a workday to get new workday? 1
Conditional Formatting with Dates 2
How can I copy data produced by a formula, not the formula? 2
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
How to shift a weekend date to the last or next workday 2
Calculating new date by entering number of additional workdays 1

Top