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....

COLUMN C
Date	1	COUNTIF($C$5:$C$12,"="&$C$7)
12/24/2017	0	COUNTIF($C$5:$C$12,"=>"&$C$7)
12/31/2017	0	COUNTIF($C$5:$C$12,">="&$C$7)
1/7/2018	0	COUNTIF($C$5:$C$12,">"&$C$7)
1/14/2018
1/21/2018
1/28/2018
2/4/2018
2/11/2018

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[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.