The formula needed to calculate % of work achieved in each month for task running more than a months

[Vanmi]

Good day Experts, I'm looking for 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 and 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 a monthly S-curve using planned vs actual days of work. Thanks in Advance.

 

[pecoflyer]

Cross post
https://www.mrexcel.com/board/threa...ulate-of-work-achieved-in-each-month.1234712/

 

[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.