I have a year's worth of employee daily data (90k records) and need to determine if an employee was part of a team that worked on a special project during a specific time frame.
I've attached a very basic sample file that should illustrate the issue.
The data on the left will be the daily record data and the data on the right will be the table that holds the list of employees that worked on the project and their start and end dates on the project.
The formula needs to compare the user id and date on the data record to a table that has the special project team's user id and start and end dates on the project.
For the record to qualify the employee must have been on the project and the daily record fall between the dates the employee was active on the project.
Any help would be greatly appreciated.
I've attached a very basic sample file that should illustrate the issue.
The data on the left will be the daily record data and the data on the right will be the table that holds the list of employees that worked on the project and their start and end dates on the project.
The formula needs to compare the user id and date on the data record to a table that has the special project team's user id and start and end dates on the project.
For the record to qualify the employee must have been on the project and the daily record fall between the dates the employee was active on the project.
Any help would be greatly appreciated.