adding only working days to dates

[bazooka]

I need to assign some dates to various deadlines for a project. I have a
list of days needed to complete each part of the project. I have the
start date (for the whole project) which could change. If i just add
the days required to the dates, they will include saturdays and
sundays. Is there any way i can add days to a date and make sure the
function only considers working days?

e.g. one part of the project takes 4 days. If the start date is on a
friday, the due date should be the next wednesday; but if the start
date is a monday, the due date should be thursday the same week.

 

[Bob Phillips]

You can use the WORKDAY function in the Analysis Toolpak (ATP) for this

=WORKDAY(start_date,num_days)

The ATP is an addin, so if you get an error, goto Tools>Addins and check it.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

 

[bazooka]

Thanks mate. That was really helpful