To Check the Headcount of Employees working continuous for 7&14 days

[fareedexcel]

Dear Experts,

Could you please help me with the below query,

I have list of employees with start date and end date worked continuously more than 7 days. Now I need to find on a particular date how many employees crossed 7-13 days and also >=14 days

Thanks

[benishiryo]

hi there, Fareed. for I6:
=COUNTIFS(E:E,">=7",E:E,"<14")

J6:
=COUNTIF(E:E,">=14")

it's great that you do uploaded an excel sample so that we do not have to manually key in your data to do a testing.

but input the desired results so that we don't have to second-guess if what we are doing is correct or not. you may look at my signature to upload an eg that is easier to understand.

if i really guessed it wrongly, please upload something according to my recommendations. try to use the solution i have given and we'll help to advise what went wrong.

[Phuocam]

Try this in I6:

=SUMPRODUCT(($H$6-$C$3:$C$401>=7)*($H$6-$C$3:$C$401<14))

in J6:

=SUMPRODUCT(--($H$6-$C$3:$C$401>=14))