Thread
:
COUNT IF A DATE IS HIGHER THAN ANOTHER DATE
View Single Post
#
3
Posted to microsoft.public.excel.misc
Mally
external usenet poster
Posts: 73
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
Reply With Quote
Mally
View Public Profile
Find all posts by Mally