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.
Hi All,
Can I have few more ideas.
Like by changing the date it should automatically distribute the quantity per month.
Thanks
Jithin
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.
if you need execl file please send me.
my ID Email is: [email protected]
have a nice day.
BENADJAL Redouane
Project engineer (Algeria)