Monthly Sales Prediction

Hello everyone,

My goal is to develop a workflow that can predict daily sales volumes for the current month, starting from the day after the current date until the end of the month (for example, if today is June 16th, I would like to predict sales from the 17th to the 30th of June). I have historical data starting from January 1st, 2024. It is essential to include seasonality analysis in the model, as I manage a physical store and must account for variations related to national holidays and Sundays.

Could you advise me on how to proceed?

Historical_Data.xlsx