Comment by jimmydorry

Have you thought about including an additional identifier for the day too? That might help in addressing the edge cases that fall on different days.