Get instant live expert help on I need help with week days list

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I need a formula for columns of times and days of week that says within these days of weeks/hours is "Inside" and outside of these days of week/hours are "outside". M-F 0900-1800, Sat 0900-1200
Solved by X. H. in 11 mins
i need a formula that tells me the end date that i will have worked 50 days if I work 2 days a week
Solved by I. F. in 29 mins
I've got a sheet for colleagues to know what days they're in. I've added another column for the amount of days they're working that week. I want the column to automatically update the amount of total days they're working that week, if an integer (the amount of hours they're working on a specific day) is inputted into a day in their row. So I've just added 8 hours into Monday, and 4 hours in Tuesday for Joe. I want the new column to then have 2 in the amount of days they're working that week.
Solved by X. J. in 24 mins
i have payroll spreadsheet and there are every day in and out time and then total hours per day and per week of worker..i just wana find out how i can calculate days that how many days he worked on this week
Solved by T. H. in 22 mins
we cant have our employees work more than 7 days in a row from previous week to next week schedules. I want an alert to notify the manager making the schedule host is scheduled 7 days in a row and cell to be highlighted in red on 7th day
Solved by C. H. in 21 mins