I am using Excel 2016 and I have a sheet where I need a horizontal series of only the weekdays of the year.
When I fill and select "Fill weekdays", it skips Saturdays, but not Sundays for some reason.
Does anyone know why this is the case and if there is a way to configure what the weekend days are.
I don't seem to find anything helpful in the Help pages or online. In all examples that people give for the Fill Weekdays feature, it skips 2 days, as it is supposed to.
Can anyone help me?
When I fill and select "Fill weekdays", it skips Saturdays, but not Sundays for some reason.
Does anyone know why this is the case and if there is a way to configure what the weekend days are.
I don't seem to find anything helpful in the Help pages or online. In all examples that people give for the Fill Weekdays feature, it skips 2 days, as it is supposed to.
Can anyone help me?