COUNTIFS to Calculate Tenure within a Date range

akrueger

I am trying to count the number of our employees that leave in the first 60 days if they were hired in a certain month while referencing another sheet.  In my original sheet I have 2 date columns (Hire date and Departure date) then a count field that calculates the net days between the two. 

This is the formula I have and I am getting an #INCORRECT ARGUMENT SET error.  I am sure it's something simple but need this completed ASAP for a dashboard.

=COUNTIFS({Onboarding Step Tracking Range 1}, @cell >= DATE(2018, 1, 1), {Onboarding Step Tracking Range 1}, @cell <= DATE(2018, 1, 31), {Onboarding Step Tracking Range 4}, <=60)

 

The last range/criteria is where i am having issues. 

Thank you!

Paul Newcome

What kind of data is the last range looking at and what type of column is it in?

akrueger

NETDAYS formula and Text/Number

Paul Newcome

Try using an @cell reference in the criteria.

 

@cell&lt;=60)

 

Let me know if that makes a difference.

akrueger

I have tried that to get the same error unfortunately! 

Paul Newcome

Are you able to share some screenshots of both sheets? Out of curiosity... Look at the source data for {Onboarding Step Tracking Range 4}. Is it left or right justified?