aravindhan_3
04-26-2016, 06:52 AM
Hi,
I have the table with the employee id in column A and 10 columns for dates ( date when the person came back to office from holidays)
in the next table I have 12 columns for 12 months, I just wanted find out how many days did the person work based on table 1.
eg: If I have 2 Jan in table 1 for Employee 1, which means the person worked for 29 Days in Jan, which has to come under Jan Column & so on.
I know my question may not be that clear, you might understand when you see a sample file that is attached.
can someone help me to get this by formula?
thanks for your help
Regards
Arvind
I have the table with the employee id in column A and 10 columns for dates ( date when the person came back to office from holidays)
in the next table I have 12 columns for 12 months, I just wanted find out how many days did the person work based on table 1.
eg: If I have 2 Jan in table 1 for Employee 1, which means the person worked for 29 Days in Jan, which has to come under Jan Column & so on.
I know my question may not be that clear, you might understand when you see a sample file that is attached.
can someone help me to get this by formula?
thanks for your help
Regards
Arvind