Hi everyone, not really sure where to start with this.
I need a macro that allows a user to input a Month and a Year on an input box. When this is done the macro would pull out the date for each Monday (in the format DD-MM-YY) in that month and paste it into four or five cells (A1:A5)
Eg for April 2014
A1 A2 A3 A4 A5 07-04-14 14-04-14 21-04-14 28-04-14
Many thanks in advance
Bookmarks