Countif to count date getting #Error

Question

Hi,&nbsp;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.&nbsp;&nbsp;Can someone help to resolve it?&nbsp;&nbsp;RegardsNishant&nbsp;

riny_van_eekelen · Answer

Nishantu309034&nbsp;Try it with a comma between D12 and "&nbsp;

nikolinode · Answer

Nishantu309034&nbsp;Count numbers or dates based on a conditionExcel for Microsoft 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007https://support.microsoft.com/en-gb/office/count-numbers-or-dates-based-on-a-condition-976d0074-245d-49e6-bf5f-1207983f82ed?ui=en-us&amp;rs=en-gb&amp;ad=gb&nbsp;With VBA:Sub datum()
   Dim inZeile As Integer
   inZeile = Application.Match(CDbl(Date), Columns(1), 1)
   MsgBox Cells(inZeile + 1, 1).Address
End SubFormula:As Mr Riny van Eekelen has also pointed out.&nbsp;NikolinoI know I don't know anything (Socrates)

nishantu309034 · Answer

Ah!.. Thanks a lot.

rajesh_sinha · Answer

Nishantu309034&nbsp;,,&nbsp;You have committed few basic mistakes.&nbsp;After the Count Range D11:D12,, COMMA is missing.Applied the operator is wrong sequence "=&lt;",, must&nbsp;be "&lt;=".And the formula should like,,,&nbsp;&nbsp;=COUNTIF(D11:D12,"&lt;="&amp;$H$10)&nbsp;&nbsp;

Forum Discussion

Countif to count date getting #Error

4 Replies

Count numbers or dates based on a condition

Resources