I have inherited a holidays planner for staff but the dates run from Oct 15 to Sep 16 whereas I need Oct 16 to Sep 17.

The details are entered on the overview page:


capture20161011110229550.png

The days are entered on a tab for each month as in the example below for October:

capture20161011111230208.png


I have taken out personal details from last year in the link below:

https://docs.google.com/spreadsheets...it?usp=sharing

Ideal Quick fix:

Can someone really help me out big time by editing the date formula so the spreadsheet can be used for October to September 17? I can then start using it immediately and populating with staff names?

So I can learn?

Give me instructions so I can do this myself, I can work it myself now with help, but ideally at leisure and I can play ready for next year?

Many thanks for any assistance/advice!

Thanks again
Colin