Formula for adding only workdays
 

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?
--
JoAnn

Formula for adding only workdays
 

See help on WORKDAY function.

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


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 12:48:15 -0800, JoAnn
wrote:

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?

Formula for adding only workdays
 

Many thanks ... that works great!

--
JoAnn


"Gord Dibben" wrote:

See help on WORKDAY function.

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


Gord Dibben MS Excel MVP

On Mon, 11 Feb 2008 12:48:15 -0800, JoAnn
wrote:

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?