Hi, I am trying to put an excel spreadsheet together to automate a rotating roster but will need to put some constraints in such as a certain function can't be rostered if it already has been in the last week or after another certain function. Does anyone have any formulas that could help that I could play with or a tutorial of where I could find this sort of stuff? Thanks