workdays formula ends on weekend date

I'm trying to calculate end dates similar to MS Project based upon a start
date and duration in workdays.

Start Date = 1/3/2006
Workdays = 28 - 1 day adjustment to get the END DATE
Holidays = ignore for now, not using it

Therefore... formula is WORKDAYS(1/3/2006,28)-1 = 2/9/2006
this is okay, but when increased to 29 days the end date should be 2/10/2006
but Excel jumps to 2/12/2006 which is a Sunday.

Why? What am i doing wrong?

Hi!

I don't know why you're subtracting a day, but you need to subtract the day
inside the function:

=WORKDAY("1/3/2006",29-1)

But if you're doing that then why not just:

=WORKDAY("1/3/2006",28)

Biff

"Charles C." <Charles [email protected]> wrote in message
news:[email protected]...
> I'm trying to calculate end dates similar to MS Project based upon a start
> date and duration in workdays.
>
> Start Date = 1/3/2006
> Workdays = 28 - 1 day adjustment to get the END DATE
> Holidays = ignore for now, not using it
>
> Therefore... formula is WORKDAYS(1/3/2006,28)-1 = 2/9/2006
> this is okay, but when increased to 29 days the end date should be
> 2/10/2006
> but Excel jumps to 2/12/2006 which is a Sunday.
>
> Why? What am i doing wrong?
>

Biff

Subtracting the day becuase workdays is inclusive of the start and end dates.

Doing it outside of the formula was the problem.
Thanks.

"Biff" wrote:

> Hi!
>
> I don't know why you're subtracting a day, but you need to subtract the day
> inside the function:
>
> =WORKDAY("1/3/2006",29-1)
>
> But if you're doing that then why not just:
>
> =WORKDAY("1/3/2006",28)
>
> Biff
>
> "Charles C." <Charles [email protected]> wrote in message
> news:[email protected]...
> > I'm trying to calculate end dates similar to MS Project based upon a start
> > date and duration in workdays.
> >
> > Start Date = 1/3/2006
> > Workdays = 28 - 1 day adjustment to get the END DATE
> > Holidays = ignore for now, not using it
> >
> > Therefore... formula is WORKDAYS(1/3/2006,28)-1 = 2/9/2006
> > this is okay, but when increased to 29 days the end date should be
> > 2/10/2006
> > but Excel jumps to 2/12/2006 which is a Sunday.
> >
> > Why? What am i doing wrong?
> >
>
>
>