Forum Discussion
Monthly headcount based on hire date formula
I am looking to take an employee roster and, using a formula, put a "Yes" if the employee was active as of the respective month (based on comparing the hire date to the last day of the month in quest...
That could be
=IF($D2<=E$1,"yes","no")and drag it to other cells. If I understood your logic correctly, please check attached file.