Counting dates after a given date

[BenElliott]

What is wrong with this formula?
{=SUM(--(FREQUENCY(IF((LocalHistory[Date]<=EOMONTH(NOW(),-48)),MATCH(LocalHistory[Talk Number In],LocalHistory[Talk Number In],0)),ROW(LocalHistory[Talk Number In])-ROW($A$2)+1)>0))}

It refers to an XL table named LocalHistory of which the below is a small extract:
If I change the operator ">=" to "<" the formula works but, with EOMONTH(NOW(),0 calculating as 30 Nov 2018 the formula should be returning a result on this table extract of 6 not the #N/A as I do. Therefore, what is wrong with this formula?[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Date
[/TD]
[TD]Talk Number In
[/TD]
[/TR]
[TR]
[TD]26/10/2014
[/TD]
[TD]110
[/TD]
[/TR]
[TR]
[TD]02/11/2014
[/TD]
[TD]99
[/TD]
[/TR]
[TR]
[TD]16/11/2014
[/TD]
[TD]100
[/TD]
[/TR]
[TR]
[TD]23/11/2014
[/TD]
[TD]123
[/TD]
[/TR]
[TR]
[TD]30/11/2014
[/TD]
[TD]141
[/TD]
[/TR]
[TR]
[TD]7/12/2014
[/TD]
[TD]9
[/TD]
[/TR]
[TR]
[TD]14/12/2014
[/TD]
[TD]50
[/TD]
[/TR]
[TR]
[TD]21/12/2014
[/TD]
[TD]67
[/TD]
[/TR]
[TR]
[TD]4/1/2015
[/TD]
[TD]88
[/TD]
[/TR]
[TR]
[TD]11/1/2015
[/TD]
[TD]158
[/TD]
[/TR]
[TR]
[TD]18/1/2015
[/TD]
[TD]98
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcelo Branco]

You formula counts the dates before (including) a given date (30 Nov 2014). It returned 5 as expected.

If you do want after 30 Nov 2014 try
=SUM(--(FREQUENCY(IF((LocalHistory[Date]>EOMONTH(NOW(),-48)),MATCH(LocalHistory[Talk Number In],LocalHistory[Talk Number In],0)),ROW(LocalHistory[Talk Number In])-ROW($A$2)+1)>0))

M.

 

[BenElliott]

Thanks for your comments, Marcelo.

You confirmed what I thought. There is nothing wrong with my formula. Therefore, there must be something wrong with my data.

On checking, I realised that, because I have some talks scheduled for some time in the future, I actually have dates in my database up to the end of 2019 but of course, the majority of these don't have talk numbers entered and it was these blank cells that was causing the #N/A error. Now I know where my formula needs amending to eliminate blank cells.

Cheers.

Ben