Hello everyone
After constantly searching for the answer I really need your help.
I'm busy with my final assignment for Management Decision Making, namely Project Scheduling.
We need to calculate the days necessary to complete the project, however it can only be the weekdays (as they want to give rest during the weekends to their employees). So I know the start date of the project (Mai 3) and the number of days every task need to be completed.
So if i put in column A 03/05/2009 and in column C 2 work days, then I want to calculate the date in column B. If I do just the normal excel calculations I get 05/05/2009 (by =Column A + column C).
But this is a continuos flow, so this does not take into account weekends (no labour).
So can somebody help me to fix this? It would be ideal that Excel calculates this and I don't need to do it by hand...
Any suggestions?
Many thanks
(ps. yes I checked EDATE and NETWORKDAYS -function, however this does not solve my problem.)
After constantly searching for the answer I really need your help.
I'm busy with my final assignment for Management Decision Making, namely Project Scheduling.
We need to calculate the days necessary to complete the project, however it can only be the weekdays (as they want to give rest during the weekends to their employees). So I know the start date of the project (Mai 3) and the number of days every task need to be completed.
So if i put in column A 03/05/2009 and in column C 2 work days, then I want to calculate the date in column B. If I do just the normal excel calculations I get 05/05/2009 (by =Column A + column C).
But this is a continuos flow, so this does not take into account weekends (no labour).
So can somebody help me to fix this? It would be ideal that Excel calculates this and I don't need to do it by hand...
Any suggestions?
Many thanks
(ps. yes I checked EDATE and NETWORKDAYS -function, however this does not solve my problem.)