Incrementing Dates

[Rokey]

Hi.
I have starting and ending dates as follows:
Cell A1 is 11/09
Cell A2 is 15/09

Cell A3 I have =TEXT(A1, "dd/mm")&" - "&TEXT(A2, "dd/mm")

This returns a result of 11/09 - 15/09 in Cell A3

In Cell B3 I want to increment the dates shown in Cell A3 by 7 days without the need of incrementing rows 1 & 2 (so leaving A1 and A2 as they are) so that B3 would be 18/09 - 22/09, C3 would be 25/09 - 29/09 etc

Any thoughts???

Tim

 

[JackDanIce]

In B3 try formula:

=TEXT($A$1+7*(COLUMN()-1),"dd/mm")&" - "&TEXT($A$2+7*(COLUMN()-1), "dd/mm")

Then copy to B3, C3 etc

 

[Rokey]

Thanks for that and it works perfectly using the cell references I gave.
For one sheet where the date range starts in column OD, in column OE I used this which seems to work:
=TEXT($OD$1+(7*COLUMNS($OD:OD)), "dd/mm")&" - "&TEXT($OD$2+(7*COLUMNS($OD:OD)), "dd/mm")
The logic fell into place pretty quickly and many thanks for your help.

 

[JackDanIce]

You're welcome