Problem with a Countifs formula

[Ilparpajim]

I use Excel 2013 and am having difficulty with a date formula.

I put this formula =COUNTIFS(Appointment_Date,">="&$G$2) into a cell. In the fx dialog box it returned a value of 640 however on the spreadsheet it shows a value of 0. Is someone able to suggest a way to fix this please.

Kind Regards

 

[bschwartz]

Can you post some sample data from Appointment_Date please? What range does that name refer to by the way?

 

[Ilparpajim]

Thanks for responding so quickly Ben. The data is on a different sheet than the calculation. There are 790 entries covering a period of three months. I need to create a formula that selects out the records in 28 day increments.
[TABLE="width: 110"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Appointment Date[/TD]
[/TR]
[TR]
[TD]11/06/14[/TD]
[/TR]
[TR]
[TD="align: right"]30/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]20/06/14[/TD]
[/TR]
[TR]
[TD="align: right"]15/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]1/09/14[/TD]
[/TR]
[TR]
[TD="align: right"]30/06/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]5/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/06/14[/TD]
[/TR]
[TR]
[TD="align: right"]31/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]12/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]22/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]10/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]5/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]23/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/06/14[/TD]
[/TR]
[TR]
[TD="align: right"]18/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]10/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]11/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]26/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]29/07/14[/TD]
[/TR]
[TR]
[TD="align: right"]15/08/14[/TD]
[/TR]
[TR]
[TD="align: right"]2/09/14[/TD]
[/TR]
[TR]
[TD="align: right"]15/08/14


[/TD]
[/TR]
</tbody>[/TABLE]

 

[bschwartz]

Is the date format on your PC setup as D/M/YYYY? What is the result if you enter this formula into B2: =N(A2)

Referencing the date on your list that reads 30/07/14.

 

[Michael M]

The formula you posted works fine for me
Check the syntax of Appointment_date as well as the formatting of G2 and the named range, as Ben suggested !

 

[Ilparpajim]

Thank you both very much. I am in a remote location at the moment and have limited web access. Will let you know the result.

Kind Regards