COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
 

What formula will work to total the number of dates in column B that are
greater than the date in Cell A1. In the example below the answer will be 2.

e.g.
Cell A1 = 21/4/2008

Cell B1 = 2/1/2007
Cell B2 = 22/4/2008
Cell B3 = 17/8/2008

COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
 

Modify to suit. Look in the help index for COUNTIF

=COUNTIF(D3:D6,""&D1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mally" wrote in message
...
What formula will work to total the number of dates in column B that are
greater than the date in Cell A1. In the example below the answer will be
2.

e.g.
Cell A1 = 21/4/2008

Cell B1 = 2/1/2007
Cell B2 = 22/4/2008
Cell B3 = 17/8/2008

COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
 

Thanks Don, that's great.

Its the part after the cell range I couldn't figure out.

"Don Guillett" wrote:

Modify to suit. Look in the help index for COUNTIF

=COUNTIF(D3:D6,""&D1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mally" wrote in message
...
What formula will work to total the number of dates in column B that are
greater than the date in Cell A1. In the example below the answer will be
2.

e.g.
Cell A1 = 21/4/2008

Cell B1 = 2/1/2007
Cell B2 = 22/4/2008
Cell B3 = 17/8/2008

COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
 

Glad to help

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mally" wrote in message
...
Thanks Don, that's great.

Its the part after the cell range I couldn't figure out.

"Don Guillett" wrote:

Modify to suit. Look in the help index for COUNTIF

=COUNTIF(D3:D6,""&D1)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mally" wrote in message
...
What formula will work to total the number of dates in column B that
are
greater than the date in Cell A1. In the example below the answer will
be
2.

e.g.
Cell A1 = 21/4/2008

Cell B1 = 2/1/2007
Cell B2 = 22/4/2008
Cell B3 = 17/8/2008