I'm trying to see trends year to year in the number of meals served at our diner in order to predict staffing and ordering.
The best arrangement would be to compare a specific day on either side of a holiday. For example, how did we do on the Monday after thanksgiving in all past years.
I realize the holidays shift so it might be hard to set up, so I could also just compare the
nth (name)day of the month. For instance, how did we do on the second Saturday of February in all previous years.
How can I do this?