Thread: Countif function - using a date range
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default Countif function - using a date range
=SUMPRODUCT(--(TEXT(M2:M999,"mmm-yy")="Sep-08"))


"Exceluser1" wrote:

My formula is COUNTIF(M2:M999,"01/09/08,30/09/08")

I want it to count if the date in the cell is in any given month - the above
isn't working.

Can anyone suggest another way to add a date range as the criteria?
Reply With QuoteReply With Quote