Forum Discussion

Copper Contributor

Sep 17, 2020

Countif to count date getting #Error

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 he...

excel

Formulas and Functions

NikolinoDE

Platinum Contributor

Sep 17, 2020

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-49e6-bf5f-1207983f82ed?ui=en-us&rs=en-gb&ad=gb

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)