Sep 17 2020 12:37 AM
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
Sep 17 2020 12:49 AM
@Nishantu309034 Try it with a comma between D12 and "
Sep 17 2020 01:01 AM
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)
Sep 17 2020 03:20 AM
You have committed few basic mistakes.
And the formula should like,,,
=COUNTIF(D11:D12,"<="&$H$10)