Thread: Use multiple criteria with COUNTIF: between dates and not blank
View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nascarfan88 Nascarfan88 is offline
external usenet poster
  
Posts: 4
Default Use multiple criteria with COUNTIF: between dates and not bla
I have a similar issue: I have a range of dates that I'm trackun using the
COUNTIF function based on the dates that are 91-180, 181-270, & 271-365, days
old, based on the TODAY date. for the 90-180days, I'm using the following,
but doesn't pan out:
=COUNTIF(MASTER!AI5:AI5997,"="&TODAY()-180),
(MASTER!AI5:AI5997,"<="&TODAY()-90)

Any help would be graetly appreciated!!

Keith


Reply With QuoteReply With Quote