Hi
Input: (Plan Table)
In Plan table I have project wise and role wise planned working hours for next six months.
Output: (Actual Table)
In actual I am using multiple resources for one role, start date and end date is mentioned in actual table.
I want Plan table should divide the hours based on start date and end date for each role. (Like I have divided hours in actual table)
Please refer attached excel file.
Re: divide plan table data in actual table using excel formula or vba
If i use =IF(AND($L5<=N$2,$M5>=EOMONTH(N$2,0)),INDEX(C:C,MATCH(1,($J5=$A$2:$A$10)*($K5=$B$2:$B$10),0)),0) this formula I am getting output (refer attached pic), but I am not getting output if the dates are in between the months.
task.png
can anyone one help me out?
Last edited by gautamaglave; 09-08-2017 at 07:32 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks