I'm not sure where to start. I tried =And(>=dates(7/6/15),<=dates(7/11/15),Sum(Form Responses1(B2:B4)) but that did not work at all. What I'm trying to do is sum only the dates that fall between week of sheet. I have 52 week of and need to transfer and sum how many occurrences fall between each one. I hope this is clear.
Bookmarks