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.