Excel formula to auto update finish date based on start date & man hours


Hello Everyone,

I need a formula to auto update a finish date in column C when i enter a Start date in column A & estimated man hours in column B considering following conditions:-

Per day working hours:- 8.5 (9:00 AM to 5:30 PM)

Weekly off on Saturday & sunday.



Please look at the left of the screen. You will find previously supplied answers to similar questions. If you don't find an answer which fits your requirement 100% you will surely find one which could be modified. Try to do the modification yourself, and if you need help come back here, posting what you have done and asking a question that might be answered.
I also draw your attention to the lable "New Service" at the top of your screen. That is where you get solutions prepared by experts without serious input from yourself, at low cost.
Variatus (rep: 983) Nov 11, '17 at 3:41 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login