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?

Date	Talk Number In
26/10/2014	110
02/11/2014	99
16/11/2014	100
23/11/2014	123
30/11/2014	141
7/12/2014	9
14/12/2014	50
21/12/2014	67
4/1/2015	88
11/1/2015	158
18/1/2015	98

<tbody>
</tbody>

 

[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