Hi All,
Not sure if I can post it here, if not please dont respond.
I need to calculate Overall Planned using if function or any other excel function. As and example I have plotted this below
On 3rd Nov I want to see the Planned % (A) = 15%
| Date | 3-Nov-21 | |
| Activity | Date | Weightage |
| Excavation | 2-Nov-21 | 5% |
| Blinding | 3-Nov-21 | 10% |
| Reinforcement and formwork | 8-Nov-21 | 30% |
| Concrete Pouring | 9-Nov-21 | 25% |
| Curing | 16-Nov-21 | 15% |
| Painting | 17-Nov-21 | 5% |
| Backfilling | 18-Nov-21 | 10% |
| Total | 100% | |
| Planned % | A |
Can it be done in excel, ie one cell (A) will say what was the planned % a range on 3 Nov 21.
Thanks
Jithin