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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
The formula needed to calculate % of work achieved in each month for task running more than a months
- Thread starter Vanmi
- Start date
Fluff
MrExcel MVP, Moderator
- Joined
- Jun 12, 2014
- Messages
- 92,489
- Office Version
- 365
- Platform
- Windows
Duplicate to: The formula needed to calculate % of work achieved in each month
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.
In relation to your question here, I have closed this thread so please continue in the linked thread.
Upvote
0
- Status
Similar threads
- Question
