Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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

0

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.

Answer
Discuss

Discussion

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: 4889) 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