Feb 03 2020 05:52 AM
I'm trying to keep track of hours per day in Excel. I want one column to fill with the dates of workdays. I found the Auto Fill function that automatically fills the days and it can also fill only workdays/weekdays, excluding the weekend. But somehow it thinks the weekend is on Tuesday and Wednesday.
Where is it getting that info? How do I fix it?
Using Office365 on a Mac, everything up to date.
Feb 03 2020 06:28 AM
SolutionMost probably default weekends are taken from OS regional settings, please check your current locale
Feb 03 2020 11:56 AM
Feb 03 2020 06:28 AM
SolutionMost probably default weekends are taken from OS regional settings, please check your current locale