employee attendance tracker - need to display April 2016 - March 2017 not 2016, 2017......

I am trying to adapt a calendar within the attendance tracker template.

I need this to show April 2016 - March 2017 and not just individual years 2016, 2017, 2018 and so on

Untitled.jpg

Untitled1.jpg

Thanks, but everytime that i delete a row, the row then becomes January and wont stay at March?

Everything works really well apart from the following;


It counts the number of days that I input into the tracker tab but does not colour the corresponding date between the months of October, November and December


Any help would be much appreciated.


Thank you

Image1.jpg

As you can see the number of days sick i 3 yet only 1 box is coloured red, the same as days time owing shows 1 but its not coloured purple anywhere?

this only happens through the months of October, November and December

I've looked at the conditional formatting and i can not see any difference?

Thank you for your help

http://www.excelforum.com/attachment...1&d=1476862373

Apologies

Thanks JohnTopley at least I know why now, do you know how I can change it?

The honest answer is No without understanding the logic of the "Calendar".

All I can say is that 1st October 2016 is Sunday in the calendar whereas it should be Saturday.

I notice on the first image you posted (if it was year 2016) that 1st October is correct i.e. a Saturday BUT the calendar started in January.

So it suggests moving to a starting month other than January "invalidates" the calculation behind the calendar.

"Pete_UK" is the calendar expert so hopefully he may pick this up.

Thank you, what you have done has helped.

I changed the detail of those months in the tracker tab to 2017 and they appeared straight away, its frustrating but I'm getting near to the end now

I really like this template, we run April to March hence why I wanted to change it and it was beyond my abilities to do so. After searching I found this version which runs April to March so thought I had it sorted

Hopefully "pete_uk" will see this and help me?

Appreciate your assistance

Well spotted Ali - seems to do the job.

@Ali,
I checked January and it is 2017.

Not sure I quite grasp the logic (haven't looked too deeply) !

You're a star.

Oh my!!!!!! (Currently doing a little dance)

Amazing!!! thank you so so much "AliGW" and to everyone else of course!!!

I wold suggest that you change the formula in C9 of the Calendar sheet to this:

=DATE($AN$5,4,1)

then in C10 you can have this formula:

=DATE(YEAR(C9),MONTH(C9)+1,1)

and you can copy this down to C20 to ensure that the dates in the calendar start in April and continue successively.

I'm not sure if the other problems have now been sorted out.

Hope this helps.

Pete

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Could you also "Add Reputation" for Ali as she solved the issue.

Hi I do not know if this is still active but I am looking to set up as an academic year starting with September ending in August and I cannot follow the steps listed
Can anyone help with a step by step guide to change?
Thank you very much

I have posted a new thread thank you - sorry I didn't realise that was what I needed to do