Thread: count number of dates in a row of cel before or after a variable d
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TBA TBA is offline
external usenet poster
  
Posts: 18
Default count number of dates in a row of cel before or after a variab
thanks very much for that- would you mind explaining the use of the quote
marks and the & ? cheers

"Gary''s Student" wrote:

=COUNTIF(N2:BR2,"<" & C2)
will count the number of dates between N2 and PR2 that are less than the
date in C2
--

Reply With QuoteReply With Quote