Compute data in other cell if cell is blank

[RoxyS]

Question: How many employees were promoted more than 7 months ago (Column C)? If they were not promoted, then how many employees were hired more than 7 months ago (Column B)?

Employee	Hire Date	Last Promotion Date
Employee 1	09/12/2013 <tbody> </tbody>	01/01/2018
Employee 2	18/04/2018 <tbody> </tbody>
Employee 3	11/06/2018 <tbody> </tbody>
Employee 4	02/08/2019 <tbody> </tbody>
Employee 5	16/05/2016 <tbody> </tbody>	11/07/2019

<tbody>
</tbody>

 

[Special-K99]

Let's establish something first.
More than 7 months ago means more than 7 months, ie 8, 9, 10, 11, 12, months etc
Not 7.
7 is not more than 7.
If you mean 7 or more then you need to include an equals in the formulas below.

Based on that

How many promoted more than 7 months ago
=SUMPRODUCT((DATEDIF(C1:C5,TODAY(),"m")>7)*(C1:C5<>""))

How many hired more than 7 months ago that were not promoted
=SUMPRODUCT((DATEDIF(B1:B5,TODAY(),"m")>7)*(C1:C5=""))

 

[Peter_SSs]

Another option

Excel Workbook
	A	B	C	D	E	F
1	Employee	Hire Date	Last Promotion Date		Promoted > 7 months ago:	1
2	Employee 1	9/12/2013	1/01/2018		Not Promoted but Hired > 7 months ago:	2
3	Employee 2	18/04/2018
4	Employee 3	11/06/2018
5	Employee 4	2/08/2019
6	Employee 5	16/05/2016	11/07/2019
Count