Google and Microsoft both allow people to use a little bit of code to make a big impact.
Let's imagine you're running a new program during a sort of free period at school. You need to track students that have the choice of multiple locations. You don't have time to get your school's attendance system in line with this new, flexible program. Instead, you'd like to share a Google Sheet with all your students and have teachers quickly note student locations using that form.
What our script will do
All we've been asked to do is automatically create a new column for every weekday. Column A will be the student's name. Column B needs to be today.