Countif, including today's date, excluding future dates

[valmir]

Hello everyone
I'm using this formula:
=COUNTIF(D3:AG3;">"&DATE(1900;1;1))
And the reason I'm using this particular formula is that within the "D3:AG3" range, I have cells with formulas whose result is not a date and/or blank cells.
I understand that this formula will count only those cells with results as date.
Now I would like this formula to be modified so as to exclude any future date but to include today's date
Thanks a lot!

 

[valmir]

I3 is the future date:

Stats 2023-24.xlsx
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI
2		UML	KAB	SAG	DHL	PET	WIL	DLS	BMQ	RCL	PRI	INT	SRC	SCC	SSC		UML	KAB	SAG	DHL	PET	WIL	DLS	BMQ	RCL	PRI	INT	SRC	SCC	SSC		10
3		4/11/23	11/11/23	17/11/23	22/11/23	6/3/24		13/2/24	14/12/23	29/12/23		10/2/24	17/2/24																		9	-1
APPS

Cell Formulas
Range	Formula
D2	D2	=INDIRECT($A3&"!$GK$5")
E2	E2	=INDIRECT($A3&"!$GK$6")
F2	F2	=INDIRECT($A3&"!$GK$7")
G2	G2	=INDIRECT($A3&"!$GK$8")
H2	H2	=INDIRECT($A3&"!$GK$9")
I2	I2	=INDIRECT($A3&"!$GK$10")
J2	J2	=INDIRECT($A3&"!$GK$11")
K2	K2	=INDIRECT($A3&"!$GK$12")
L2	L2	=INDIRECT($A3&"!$GK$13")
M2	M2	=INDIRECT($A3&"!$GK$14")
N2	N2	=INDIRECT($A3&"!$GK$15")
O2	O2	=INDIRECT($A3&"!$GK$16")
P2	P2	=INDIRECT($A3&"!$GK$17")
Q2	Q2	=INDIRECT($A3&"!$GK$18")
R2	R2	=INDIRECT($A3&"!$GK$19")
S2	S2	=INDIRECT($A3&"!$GK$20")
T2	T2	=INDIRECT($A3&"!$GK$21")
U2	U2	=INDIRECT($A3&"!$GK$22")
V2	V2	=INDIRECT($A3&"!$GK$23")
W2	W2	=INDIRECT($A3&"!$GK$24")
X2	X2	=INDIRECT($A3&"!$GK$25")
Y2	Y2	=INDIRECT($A3&"!$GK$26")
Z2	Z2	=INDIRECT($A3&"!$GK$27")
AA2	AA2	=INDIRECT($A3&"!$GK$28")
AB2	AB2	=INDIRECT($A3&"!$GK$29")
AC2	AC2	=INDIRECT($A3&"!$GK$30")
AD2	AD2	=INDIRECT($A3&"!$GK$31")
AE2	AE2	=INDIRECT($A3&"!$GK$32")
AF2	AF2	=INDIRECT($A3&"!$GK$33")
AG2	AG2	=INDIRECT($A3&"!$GK$34")
AI2	AI2	=COUNTIF(D3:AG3,">"&DATE(1900,1,1))
D3	D3	=INDIRECT($A3&"!$GI$5")
E3	E3	=INDIRECT($A3&"!$GI$6")
F3	F3	=INDIRECT($A3&"!$GI$7")
G3	G3	=INDIRECT($A3&"!$GI$8")
H3	H3	=INDIRECT($A3&"!$GI$9")
I3	I3	=INDIRECT($A3&"!$GI$10")
J3	J3	=INDIRECT($A3&"!$GI$11")
K3	K3	=INDIRECT($A3&"!$GI$12")
L3	L3	=INDIRECT($A3&"!$GI$13")
M3	M3	=INDIRECT($A3&"!$GI$14")
N3	N3	=INDIRECT($A3&"!$GI$15")
O3	O3	=INDIRECT($A3&"!$GI$16")
P3	P3	=INDIRECT($A3&"!$GI$17")
Q3	Q3	=INDIRECT($A3&"!$GI$18")
R3	R3	=INDIRECT($A3&"!$GI$19")
S3	S3	=INDIRECT($A3&"!$GI$20")
T3	T3	=INDIRECT($A3&"!$GI$21")
U3	U3	=INDIRECT($A3&"!$GI$22")
V3	V3	=INDIRECT($A3&"!$GI$23")
W3	W3	=INDIRECT($A3&"!$GI$24")
X3	X3	=INDIRECT($A3&"!$GI$25")
Y3	Y3	=INDIRECT($A3&"!$GI$26")
Z3	Z3	=INDIRECT($A3&"!$GI$27")
AA3	AA3	=INDIRECT($A3&"!$GI$28")
AB3	AB3	=INDIRECT($A3&"!$GI$29")
AC3	AC3	=INDIRECT($A3&"!$GI$30")
AD3	AD3	=INDIRECT($A3&"!$GI$31")
AE3	AE3	=INDIRECT($A3&"!$GI$32")
AF3	AF3	=INDIRECT($A3&"!$GI$33")
AG3	AG3	=INDIRECT($A3&"!$GI$34")
AH3	AH3	=COUNTIFS(D4:AG4,">0",D4:AG4,"<=1000")
AI3	AI3	=AH3-AI2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
AI3	Cell Value	<0	text	NO
B2:B46,D2:AI46	Cell Value	=0	text	NO

 

[Peter_SSs]

Thanks for that. What about this?

=COUNTIFS(D3:AG3,">0",D3:AG3,"<="&TODAY())

 

[valmir]

Thanks for that. What about this?

=COUNTIFS(D3:AG3,">0",D3:AG3,"<="&TODAY())

Worked perfectly! Thank you so much and for your patience too!

 

[Peter_SSs]

You're welcome. Glad we got there in the end. Thanks for the follow-up.