Download File: https:\/\/ift.tt\/2AYwOFj
\nEntire page with all Excel Files for All Videos: https:\/\/ift.tt\/1kSFWvs<\/p>\n
In this video see how to count how many employees have worked for the company between 1 and 6 years, based on a hire date. See 8 examples of different formulas and Conditional Formatting.
\nTopics:
\n1. (00:06) Introduction
\n2. (01:13) TODAY Function
\n3. (01:44) EDATE Function for Lower Limit for counting between lower date and upper date. EDATE for upper limit formula too.
\n4. (03:08) COUNTIFS to count between lower and upper dates. Learn about how the comparative operator in COUNTISF requires quotes. Formula Counts Between a Lower & Upper Limit.
\n5. (04:41) AND Function Helper Colum for logical TRUE \/ FALSE formula. Learn about how the comparative operators in Logical Formulas do NOT require quotes.
\n6. (06:35) COUNTIFS function with TRUE criteria. Count Number of TRUE values.
\n7. (06:57) SUMPRODUCT Function to add the number of TRUE values. Add Number of TRUE values.
\n8. (08:47) Conditional Formatting Formula to highlight the employee records (highlight row) where the employee has worked for company between one to six years.
\n9. (11:40) One Complete Mashed Up Formula that does not require intermediate cells with formulas. Learn a lot of how you can copy and paste formula elements from intermediate cells into one final formula \u2013 huge mega formula.
\n10. (13:46) Summary<\/p>\n