Forum Discussion
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...
basically... remove the last day before doing the count on each "end" finish date should work..
-1 on each end day.. they do the normal formula
-1 on each end day.. they do the normal formula
How about
=SUM((INT($B$3:$B$10)<=A15)*(INT($C$3:$C$10)>A15))
for the original data range, and
=SUM((INT($G$4:$G$51<=A15)*(INT($H$4:$H$51)>A15)))
for the one on the right.
Fill down.