Counting dates past X

[Kerry Newman]

I am trying to count the dates AFTER 1/7/2018
The first formula is "= to 1/7/218" and gives me a 1 which is correct

The next three do nothing, gives me a 0... not correct.
What am I doing wrong? in Excel 2016....


[TABLE="width: 409"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]COLUMN C[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]1[/TD]
[TD]COUNTIF($C$5:$C$12,"="&$C$7)
[/TD]
[/TR]
[TR]
[TD]12/24/2017[/TD]
[TD]0[/TD]
[TD]COUNTIF($C$5:$C$12,"=>"&$C$7)
[/TD]
[/TR]
[TR]
[TD]12/31/2017[/TD]
[TD]0[/TD]
[TD]COUNTIF($C$5:$C$12,">="&$C$7)
[/TD]
[/TR]
[TR]
[TD]1/7/2018[/TD]
[TD]0[/TD]
[TD]COUNTIF($C$5:$C$12,">"&$C$7)
[/TD]
[/TR]
[TR]
[TD]1/14/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/21/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1/28/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/4/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2/11/2018[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Marcílio_Lobão]

Kerry Newman, Good afternoon.

Your formulas:

a) COUNTIF($C$5:$C$12,"="&$C$7) --> CORRECT --> Result must be 1

b) COUNTIF($C$5:$C$12,"=>"&$C$7) --> WRONG SINTAXE

c) COUNTIF($C$5:$C$12,">="&$C$7) --> CORRECT --> Result must be 6

d) COUNTIF($C$5:$C$12,">"&$C$7) --> CORRECT --> Result must be 5

Verify your dates at C5:C12 and C7.

Are they REAL dates or maybe some TEXT dates there?

I hope it helps.

 

[Kerry Newman]

Kerry Newman, Good afternoon.

Your formulas:

a) COUNTIF($C$5:$C$12,"="&$C$7) --> CORRECT --> Result must be 1

b) COUNTIF($C$5:$C$12,"=>"&$C$7) --> WRONG SINTAXE

c) COUNTIF($C$5:$C$12,">="&$C$7) --> CORRECT --> Result must be 6

d) COUNTIF($C$5:$C$12,">"&$C$7) --> CORRECT --> Result must be 5

Verify your dates at C5:C12 and C7.

Are they REAL dates or maybe some TEXT dates there?

I hope it helps.

Thanks for the input, the dates are formatted as dates. and c & d above bring back 0
What do you think is going on?

 

[Marcílio_Lobão]

Kerry Newman,

"...the dates are formatted as dates..."
They are formatted as DATES....BUT..Are they REAL DATES for Excel???

Take a little test:
Choose any cell. e.g. G5

G5 --> =ISNUMBER(C5)
Copy it down to G12

ALL the answers must be TRUE.

It will confirm IF all your dates are REAL DATES for Excel.

I will wait for your answer.

 

[Kerry Newman]

Kerry Newman,

"...the dates are formatted as dates..."
They are formatted as DATES....BUT..Are they REAL DATES for Excel???

Take a little test:
Choose any cell. e.g. G5

G5 --> =ISNUMBER(C5)
Copy it down to G12

ALL the answers must be TRUE.

It will confirm IF all your dates are REAL DATES for Excel.

I will wait for your answer.

Very Nice, they were not dates. They were formatted as dates but when I clicked in the cell and hit enter on each cell, the formulas worked.
Thanks a ton!
Kerry

 

[Marcílio_Lobão]

Kerry,

Glad to have helped you.

Thanks for the feedback.