Distribution by change in Date - Excel
- Created
- 2
- 3
Hello Team,
Need your support in solving a proble. I have made a table with start date (A) and Finish date (B), The total Quantity (C) is divided by the durtation to give the per day quantity (D). Now I have per month cut of date (E, F, G, H).
Can anyone propose a formula for E. F, G, H, where the quantity would change when I change the start (A2) and finish (B2) based on the date in E2, F2, G2 and H2.
2 replies
Oldest first- 0Benadjal Redouane ·
Hello, please find to
Hello, please find to attached file.
the quantity change when you change the start date and finish date and the dates in E2, F2, G2 and H2 change also.
Your exemple: Start Finish Duration Total Qty Per Day 27/09/2024 25/10/2024 29/11/2024 27/12/2024 Total Duration 1 Qty 1 Duration 2 Qty 2 Duration 3 Qty 3 Duration 4 Qty 4 09/09/2024 27/12/2024 110,00 1000 9,09090909 19,00 172,727273 28,00 254,545455 35,00 318,181818 28,00 254,545455 1000 Change date start and finish Start Finish Duration Total Qty Per Day 29/10/2024 26/11/2024 31/12/2024 25/02/2025 Total Duration 1 Qty 1 Duration 2 Qty 2 Duration 3 Qty 3 Duration 4 Qty 4 11/10/2024 25/02/2025 138,00 1000 7,24637681 19,00 137,681159 28,00 202,898551 35,00 253,623188 56,00 405,797101 1000 if you need execl file please send me.
my ID Email is: redouanebenadjel@gmail.com
have a nice day.
BENADJAL Redouane
Project engineer (Algeria)
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?