Counting zeros whilst cross checking number of times they happened

Hi guys   Help please!   I am trying to establish lead times for my hotel website bookings. I have exported data out of Google Analytics into excel that tells me the date someone searched for...