View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ann ann is offline
external usenet poster
 
Posts: 210
Default date calculation

i currently have this formula
=COUNTIF(A1:A15,"5/18/2008")-COUNTIF(A1:A15,"5/22/2008")
if i want to pull the dates and put them in a separate field and reference
that field, how do i do it? the syntax i have won't work.

i'm trying =COUNTIF(M6:M400,"$b$1")-COUNTIF(M6:M400,"$b$2") where
b1=5/18/2008 and b2=5/22/2008

TIA