View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gnealeuk Gnealeuk is offline
external usenet poster
 
Posts: 2
Default Countif using cell refences

i would like to add a formula into my spreadsheet that counts if a date in a
previous cell appears, but the date is constantly being changed so therefore
i would like the formula to contain a cell reference instead of the date,
other problem is that the date will be encoded in other data, therefore i
need to wild card it at the beggining and the end with *'s but it doesnt seem
to want to work with a cell reference and not a constant number