Countif to count date getting #Error

[Nishantu309034]

Hi, 

I am trying to count if a range of dates is greater or lesser than a particular date but facing Error. Please see the cell H11. You can check the formula in the formula bar. 

Can someone help to resolve it? 

Regards

Nishant 

[#2]

@Nishantu309034 Try it with a comma between D12 and "

[#3]

@Nishantu309034 

Count numbers or dates based on a condition

Excel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007

https://support.microsoft.com/en-gb/office/count-numbers-or-dates-based-on-a-condition-976d0074-245d...

With VBA:

Sub datum()
   Dim inZeile As Integer
   inZeile = Application.Match(CDbl(Date), Columns(1), 1)
   MsgBox Cells(inZeile + 1, 1).Address
End Sub

Formula:

As Mr Riny van Eekelen has also pointed out.

Nikolino

I know I don't know anything (Socrates)

[#4]

Ah!.. Thanks a lot.

[#5]

@Nishantu309034 ,,

You have committed few basic mistakes.

1. After the Count Range D11:D12,, COMMA is missing.
2. Applied the operator is wrong sequence "=<",, must be "<=".

And the formula should like,,, 

=COUNTIF(D11:D12,"<="&$H$10)