Forum Discussion
Need help forecasting
I'm not understanding what you're not understanding. Your original post asked, and I quote:
I am trying to determine based on when customers have all scheduled dates previously, what days or dates they are going to most likely be scheduling in the future is there a way to do this?
I didn't specifically do "forecasting" at all; never intended to. What I gave you from the, admittedly, limited set of data shows the pattern of previous activity (to the extent there is one), by day of the week, by month. Isn't that what you wanted? You're the one who then will base your forecasting on that.
If you're saying you don't understand how to do a Pivot Table based on data, I suggested some research on YouTube or Google. Here's a specific link that should be helpful. https://exceljet.net/search?query=pivot+table
And YouTube has many instructional videos on the topic.
If there's something else that you're seeking beyond these, then please spell it out a bit more. Forecasting itself is inherently quite subjective; and I think that is especially true in a case such as yours. But seeing the pattern in the previous activity is a good starting point.