Automatic week and date

[ChrisStadh89]

Hi,

In column A, field 1 i want to post the text "Week 2, 6-10 Jan" with 5 days in the week. Field 2, "Week 3, 13-17 jan" And then i just want to pull this field down in the column, but then the week number changes and the date interval. Is there any way do to this or something simular?

Thanks!

Christopher

[alansidman]

I would do it with three columns. Because you are trying to autofill text, you will need a complex set of formulae to accomplish this. I suggest that you autofill column A with values 2 to 52, then in column B1 type Start and in C1 End
In b2 type 1/6/2014
In c2 type 1/10/2014
In b3 type = b2 +7 and copy down
In c3 type = c2 +7 and copy down