To calculate % Completed for that month.

[Vanmi]

Good Morning All, I'm trying to write an Excel formula, but not getting the intended results, If any Excel advanced users in our team, help me with this formula. Here is the scenario, I'm trying to calculate the duration achieved for each month. Take a look at the image attached, for the task name "Build", have a duration of 9 days, both start and finish date are in the same month,60% completed. so the duration achieved for March 2023 month is calculated as duration multiplied by % Complete. and for the next task "Supervision" have a duration of 140 days starting on March 05 23 to 04 June 23, now how to calculate the Duration Achieved for the month of March 2023? as the finish date falls under a different month? I'm looking for any formula or function suggestions in Excel.

 

[pecoflyer]

Cross post https://www.mrexcel.com/board/threads/to-calculate-completed-for-that-month.1234744/

 

[vletm]

Vanmi
Please reread and follow Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

• Cross-Posting. Generally, it is considered poor practice to cross post. That is to post the same question on several forums in the hope of getting a response quicker.
• If you do cross-post, please put that in your post.
• Also if you have cross-posted and get an Solution elsewhere, have the courtesy of posting the Solution here so other readers can learn from the answer also, as well as stopping people wasting their time on your answered question.