Experience Ms Excel 2010 expert

Closed - This job posting has been filled.

Job Description

I have Ms Excel file and its have a columns Like that

These are Mondays of the year 2013

1/7/2013 1/14/2013 1/21/2013 and so on I always insert value manually on yearly basis i want VBA not macro code that automatically convert this column into any year of Monday example

These are Mondays of the year 2014
1/6/2014 1/13/2013 1/20/2013

Please let me know can you do this simple work I will provide you file on interview.