Date range drag

[thedeadzeds]

Hi All,

I have a spreadsheet which shows date ranges in one cell i.e:

I need to enter the new weeks but cannot seem to drag these down, it appears I can only enter these manually.

Is there any way of doing this? I have attached the spreadsheet

Many thanks


01/11-07/11
08/11-14/11
15/11-21/11
22/11-28/11
29/11-05/12
06/12-12/12
13/12-19/12

[benishiryo]

hi there. try:
=TEXT("6sep2014"+(ROWS(B$2:B2)-1)*7,"dd/mm-")&TEXT("12sep2014"+(ROWS(B$2:B2)-1)*7,"dd/mm")

and do update your excel version in your profile. it helps us know that you have a new version of excel & can help you with new formulas. i noticed your file extension is xlsx, so i assume it's excel 2007 & above