Hi to all experts,
I am looking for a formula which split the value throughout date range as per start and finish milestone dates:
example : Item A has start and finish date and total duration for it is 65 days, total manhours/value for it is 1,000. so I want monthly values to be allocated in January, February & March (taking into consideration range from G5 to AP5) as I reflected data manually.
example sheet is attached for reference
thanks....
Bookmarks