I am making a template to keep in and out times for individuals of 2 seperate groups..

The users of this template are not too computer savvy and I would like to try and make it as easy as possible.

Ideally I would like to set the month/year in a drop down within box A1 or A2. Then turn around and use that month/year as a criteria to autofill the days in row 1 and the corresponding dates in row 2.

Anyone have any ideas please?

Annotation 2019-08-13 083347.png