Rotating shift

Originally Posted by Neil_

Paste my formula in a blank workbook in any other cell than A2 and type your date in A2.

OK Cool, with some slight modification on the order of the "off's and On's" it worked!