Thread: counting dates within a rnage
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carim[_3_] Carim[_3_] is offline
external usenet poster
  
Posts: 137
Default counting dates within a rnage
Hi John,

As a first step, following formula will do the job :
=COUNTIF(A1:A10,"06.03.2006")

if all your dates are located in A1:A10 range,
and if today is your reference point ...

HTH
Cheers
Carim

Reply With QuoteReply With Quote