Formula for adding only workdays

  • Thread starter Thread starter JoAnn
  • Start date Start date
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?
 
See help on WORKDAY function.

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


Gord Dibben MS Excel MVP
 
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...
 
Back
Top