Business Days Calculation from Calendar

[RB]

Hi,

One of the column in the project plan is Business Day, which requires manual
input .

The relationship between Business Days and Calendar Days for month 1 is
generally different to the relationship between Business Days and Calendar
Days for month 2. e.g.
In Oct, 3rd Oct Fri is BD 3
In Nov, 3rd Nov Mon is BD1 (as Nov 1 and 2 fall on weekend)
In Dec, 3rd Dec is BD 3
In Jan, 3rd Jan is a non working day as it is on weekend

Thus, every month BD column requires a manual entry. Is it possible to have
a formula which calculates Business Day based on working calendar day?

Thanks,

 

[Jim Aksel]

You may have to apply some nested functions to do the calculation for you, I
haven't played with it. I'd go after it with the Date, Day, and WeekDay
functions.

For certain, the calculation is possible using Visual Basic for Applications
(VBA).
--
If this post was helpful, please consider rating it.

Jim Aksel, MVP

Check out my blog for more information:
http://www.msprojectblog.com

 

[pingaa]

In excel you can use "networkdays" function to calculate # of biz days
between two dates. Not sure how to project out # of business days between
known and unknown.

 

[Dave]

What does the column actually represent - is it the business day of the
start or finish of the task?