Thread: Counting of a date from a range of Cells
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
  
Posts: 8,651
Default Counting of a date from a range of Cells
=COUNTIF(A1:A10,"="&DATE(2009,1,1))-COUNTIF(A1:A10,""&DATE(2009,1,5))
if you want the date limits to be inclusive.
If you want the limits to be exclusive, swap the and = signs.
--
David Biddulph

Manikandan wrote:
I have a coulumn which contains somany dates in DD-MM-YY format. I
want to count the number of cells which contain a range of dates like
from 01.01.09 to 05.01.09 etc..

Please help me..


Reply With QuoteReply With Quote