I'm trying to create an idiot-proof spreadsheet for our family business staff
wages:

I have made a drop down list from January - December,
and a second list from 2008 - 2019, these values form the headings of each
subsequent page inc. staff payslips.

I am able to select APRIL from a dropdown in cell B3; 2008 from a dropdown
in CELL B5 ... BUT .... when those are selected I would like cell B7 to
display
"Pay Period 29/03/08 to 28/04/08" (or the appropriate Pay period for the
month/year combination)