View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Spiky Spiky is offline
external usenet poster
 
Posts: 622
Default Count range of data

On Aug 26, 3:26 pm, "Don Guillett" wrote:
Look at the COUNTIF function


And also...

You can't enter a date like that in a formula. The best way is to put
your limit date in a cell somewhere and reference it. Or you can use
DATE or DATEVALUE to put the date into the formula.