2017 active employee by month

[y3tter]

I have a sheet the has employee names in column A. Column B contains their hire date, which could be 2017 or any prior year. Column C is termination date, which could also be 2017 or any prior year. Column D is re-hire date. Columns E-P are months Jan - Dec. What formula can I use to establish in each month if the employee was employed? As long as they worked one day of the month, they would be considered "Full Time", otherwise they would need to be flagged as "Not-Working".

Not all employees have a termination date or re-hire, but each employee listed did work at least one day of 2017.

 

[mopp1]

Assuming data starts in row 2 and headers in row 1. Assuming E1:P1 contain dates (not just Jan, Feb, etc.) corresponding to the first of each month of 2017 (you can format as MMM to show up as month headers, but the underlying cell needs to contain the specific date).

Put the following in E2 and drag though column P and down to end of data:

=IF(OR(AND($B2<>"",$B2<=EOMONTH(E$1,0),OR($C2>E$1,$C2="")),AND($D2<>"",$D2<=EOMONTH(E$1,0))),"Full Time","Not-Working")

 

[y3tter]

Assuming data starts in row 2 and headers in row 1. Assuming E1:P1 contain dates (not just Jan, Feb, etc.) corresponding to the first of each month of 2017 (you can format as MMM to show up as month headers, but the underlying cell needs to contain the specific date).

Put the following in E2 and drag though column P and down to end of data:

=IF(OR(AND($B2<>"",$B2<=EOMONTH(E$1,0),OR($C2>E$1,$C2="")),AND($D2<>"",$D2<=EOMONTH(E$1,0))),"Full Time","Not-Working")

Awesome, thank you!!