I've got a bunch of cells that have formulas to display the day of the week according to the date above it. (I'm using Google Sheets by the way)
I want the cell underneath the day of the week that has been calculated, to display a number (which is the number of stylists in the salon on that day usually) on that day of the week. i.e if the cell above says 'Tues' then to display '5' and if it says Weds to display '4' and so on....
So row 1 is date, row 2 is day of the week (calculated by the date in row 1) and I want the cells in row 3 to display the number of my wishing dependant on the day in row 2. I hope this makes sense? I tried the 'if' formula but couldn't seem to master it!
It won't let me add images, so here is the link to the master sheet: https://docs.google.com/spreadsheets/d/1wqtMktTHcc1ldztyI_ctu58nPxRiUt6owaoOh1_KzjM/edit?usp=sharing