I have recently become part of a restaurant management team. Previously they have used excel very basically, just manually inputting every piece of data rather than using formulas.
I'm trying to idiot proof everything so that they don't have to waste so much time anymore.
Right now I am working on a workbook they have that they print out every other week, previously they had to manually change all the dates (on 42 pages). I have it now so that if the workbook is printed on the day before they are needed (Sunday) all they need to do it open it up and print, just using TODAY()+1 and so on
I am trying to an IF function to idiot proof it so if they have to print it on a Monday for whatever reason the dates will be correct. Just a proviso, if the work isn't printed on the Sunday, it absolutely must be printed on the Monday.