Im trying to make a simple calorie counting sheet as a protoype to an app, users answer a form whose data is loaded into a sheet and then a page which calculates a daily count but the criterion is dd/mm/yyy and the range to check for matches is autoformatted from google forms as dd/mm/yyy hh:mm:ss and i can’t figure out the formula to make it work.