How to count number of employees days on work between 2 dates (countif etc)

Question

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 to 4 march

I wanna count each day and show how many work on each day on shift.

In this simple example on 16th I have 1 employee working, and on 17th I have 2 etc.

Any tips on moving on? I have been playing around with countif but no success yet 🙂

I basically wanna fil out the Persons on shift for each day from the "calendar" above that's 2 dates in each column.

hansvogelaar · Answer

Swe_Mack&nbsp;
Let's say the start dates are in B3:B10 and the finish dates in C3:C10.
&nbsp;
The lit of dates below starts in A15.
In B15:
=COUNTIFS($B$3:$B$10, "&lt;="&amp;A15, $C$3:$C$10, "&gt;=&amp;A15)
Fill down.

swe_mack · Answer

Thanks for helping out! I made a simple excel and put the boxes in. But I can't get it to work..https://1drv.ms/x/s!AgVMgapiFJvPgZAwNWKDix56QnnYSw?e=sDzfakIdeas?

swe_mack · Answer

Snippet if u don't wanna click the link.&nbsp;&nbsp;Swe_Mack&nbsp;

hansvogelaar · Answer

Swe_Mack&nbsp;
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 · Answer

It works perfectly! Thank you so much!

Forum Discussion

How to count number of employees days on work between 2 dates (countif etc)

Share

Resources