Formula for adding only workdays

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JoAnn - 11 Feb 2008 20:48 GMT

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?

Signature

JoAnn

Reply to this Message

Gord Dibben - 11 Feb 2008 22:51 GMT

See help on WORKDAY function.

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

Gord Dibben MS Excel MVP

>I need to have a date column that contains a date that is 3 workdays from the
>date specified in another column ("date submitted").
[quoted text clipped - 3 lines]
>
>Is there a way to do that?

Reply to this Message

JoAnn - 13 Feb 2008 16:50 GMT

Many thanks ... that works great!

Signature

JoAnn

> See help on WORKDAY function.
>
[quoted text clipped - 9 lines]
> >
> >Is there a way to do that?

Reply to this Message