just put the real date for jan 1 2014 in a cell format as dddd for week date and yyyy for year
for subsequent years use edate(1/1/2014,12),edate(1/1/2014,24) and so on