I've been trying to create a shift leave roster for work, which works around a 4 year revolving roster. I want to be able to input a year at the top and have it adjust accordingly for all future years but every time i put in a leap year it throws the answer off by 1.
This is what I currently have in C14:
Capture.PNGPlease Login or Register to view this content.
Bookmarks