Excel help

Hello, I'm trying to figure out what formula I would use to add the number of people in each household (column B) that come to our food pantry every week by putting a 1 in the date columns (D,E, etc....