Thread: Counting the number of times a certain date appers
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default Counting the number of times a certain date appers
Format as General (it's probably formatted as date now)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"ignitedaz" wrote in message ...
| I'm using the following simple formula to count how many times a date appears
| in a spreadsheet; =COUNTIF(GG!A2:A200,A2). I returns "1/2", why is this? And
| how do I fix this?


Reply With QuoteReply With Quote