Counting value with Date saved as Text

[mart_mrexcel]

I have a data table with date (from SAP) and status to count the number of “inactive” in a given date. Im using the countifs formula. Problem is, Im always getting zero because the date column is extracted from SAP where it is a text format as (eg) 2022.03.01. Query, what formula I can use directly in the criteria range to directly read the SAP date as true date.

	A	B	C	D	E	F
1	Date	Status
2	2022.03.01	Inactive		Enter Date	2022-03-01
3	2002.06.16	Active		Inactive Count	=COUNTIFS($B$2:$B$6,"Inactive",$A$2:$A$6,E2)
4	2022.01.01	Active
5	2012.08.17	Active
6	2022.03.31	Inactive

 

[kevin9999]

Try the following

Book1
	A	B	C	D	E
1	Date	Staus
2	2022.03.01	Inactive		enter date	2022-03-01
3	2002.06.16	Active		Inactive Count	1
4	2022.01.01	Active
5	2012.08.17	Active
6	2022.03.31	Inactive
Sheet1

Cell Formulas
Range	Formula
E3	E3	=COUNTIFS($A$2:$A$6,TEXT($E$2,"yyyy.mm.dd"),$B$2:$B$6,"Inactive")

 

[mart_mrexcel]

Try the following

Book1
	A	B	C	D	E
1	Date	Staus
2	2022.03.01	Inactive		enter date	2022-03-01
3	2002.06.16	Active		Inactive Count	1
4	2022.01.01	Active
5	2012.08.17	Active
6	2022.03.31	Inactive
Sheet1

Cell Formulas
Range	Formula
E3	E3	=COUNTIFS($A$2:$A$6,TEXT($E$2,"yyyy.mm.dd"),$B$2:$B$6,"Inactive")

Thanks Kevin, that works perfect.

 

[kevin9999]

Thanks Kevin, that works perfect.

You're welcome and thanks for the feedback.