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)?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Employee[/TD]
[TD]Hire Date[/TD]
[TD]Last Promotion Date[/TD]
[/TR]
[TR]
[TD]Employee 1[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]09/12/2013[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]01/01/2018[/TD]
[/TR]
[TR]
[TD]Employee 2[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]18/04/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 3[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]11/06/2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 4[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]02/08/2019[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Employee 5[/TD]
[TD][TABLE="width: 123"]
<tbody>[TR]
[TD="class: xl65, width: 123"]16/05/2016[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]11/07/2019[/TD]
[/TR]
</tbody>[/TABLE]

 

[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