What is the excel formula to create a every monday of a year?

Question

Is there a formula to create every Monday for 2011 using excel? Like a list of dates for all the Monday's of the year?

Answer 1

I recently created a workbook to give the starting date of each week of the year (so if the first week of the year starts on a day other than Monday, it will give the correct date for that short week).



Put the year in cell B2, put the week numbers 1-53 in columns G1:BG1

Use this formula in cell G2 then drag-copy across to BG2:

=TEXT(IF(G$1=1,DATE($B$1,1,1), (DATE($B$1,1,1) - WEEKDAY( DATE($B$1,1,1),3)) + (G$1-1)*7),"ddd dd mmm")

Answer 2

if you take the first Monday of 2011 (01/3/2011) and put in A1

then in A2 type 1/10/2011

select both cells, move your cursor to the bottom right corner of A2 until it turns into a plus sign, click and drag down until you have the full year (52 rows). Excel will continue the pattern.

Answer 3

list all the dates, in next column place corresponding weekday, then sort it by weekdays and you have all the dates.

The best place to get exact howto is excel help.



OR get first column in date format,

place first date of monday in A1,

in A2 place formula =A1+7,

in A3 place formula =A2+7

....