Formula referencing table name help

[Outdoorsman80]

I have multiple worksheets, worksheet G has a table with the name "tblExample". On worksheet A, I want to count the amount of rows that have data between a year.

Finances.xlsx
	A	B	C	D	E	F	G
1	Product	Brand	Details	Date	Price	Gone	D. Depleted
2	Prod1	Brand1	612G.11	2019/12/01	$ 2.75	No
3	Prod2	Brand2	13354A	2019/12/31	$ 2.50	No
4	Prod3	Brand2	L6794	2020/12/31	$ 2.50	No	4/2/2020
5	Prod4	Brand2	1717P	2019/12/31	$ 3.00	No
6	Prod5	Brand1	232/A	2021/12/31	$ 2.75	No
7	Prod6	Brand1	4518P	2019/12/31	$ 2.75	No
8	Prod7	Brand3	L1046A	2019/12/31	$ 2.50	Yes	1/1/2021
worksheet G

Finances.xlsx
	A	B
13	Products purchased in 2021	2
worksheet A

Cell Formulas
Range	Formula
B13	B13	=COUNTIFS(tblExample,">="&DATE(2021,1,1),tblExample,"<="&DATE(2021,12,31))

You can see that for products purchased in 2021, it shows two, but it should just be 1. It looks like it's picking up the date in the G column as well. How can I specify just the D column without D2:Dx?

 

[Fluff]

You need to include the column name as well, like

=COUNTIFS(tblexample[Date],">="&DATE(2021,1,1),tblexample[Date],"<="&DATE(2021,12,31))

 

[Outdoorsman80]

I was experimenting with quotes; so when referencing a table name you use the brackets... Thank you!

 

[Fluff]

You're welcome & thanks for the feedback.