I am attempting to figure out how I could take six cells and depending which
one a user clicks on, its date will be displayed in one cell. the six cells
display the next 6 mondays, week start dates. And to use an elaborate
calculation I have made, they have to input the week that they want to look
at. Right now they type in the monday they want by referencing the list, but
I would like to be able to put in a button that will not only input the date
for them, but will continue to update as time goes on (ie next week it will
show the next 6 mondays, not the same 6 as this week) I am working through a
VBA book to try and figure this out, but I am stuck, any ideas? Thanks.