Forum Discussion
Swe_Mack
Feb 11, 2024Copper Contributor
How to count number of employees days on work between 2 dates (countif etc)
Hi, I'm trying to figure out how to make excel check 2 dates on each row and see if if that person is active on work. For example. Employee 1 works 16 feb to 3 march Employee 2 works on 17 feb...
HansVogelaar
Feb 11, 2024MVP
I forgot one quote, but the formula has to be different since the start and finish values have a time component.
I have updated your workbook.
Swe_Mack
Feb 11, 2024Copper Contributor
It works perfectly! Thank you so much!