workdays formula ends on weekend date

G

Guest

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

Biff

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
 
G

Guest

Biff

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

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

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

Top