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