The formula needed to calculate % of work achieved in each month

[Vanmi]

I need a formula for a task running more than one month and need the % completion of each monthly update. For example, if a task is 140 days in duration start date is March 05 2023 to the Finish date is 15 Dec 2023, and Now the current date is Apr 30, 2023, and 15% of tasks are completed. how to calculate No of days achieved for the month of April 2023. just a note, I need these data to prepare monthly S-curve using planned vs actual days of work

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: The formula needed to calculate % of work achieved in each month for task running more than a months
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.