Formula request...

[Matty]

Hello All,

Let's say Cell A1 has a date of 31/12/2007 in it. I want formula that will populate Cell C1 with the same date, but when copied down to Cell C2, it will show the date plus 7 days (i.e. 07/01/2008), and when copied down to Cell C3, plus another 7 days (i.e. 14/01/2008) and so on...

I know I can do something like this, where C1 is simply =B1 and is C2 =C1+7, then copied down, but I ideally want a formula that is the same from C1 all the way down.

Any suggestions most welcome.

Matty

 

[Andrew Poulsom]

How about?

=A$1+((ROW(A1)-ROW(A$1))*7)

 

[dafan]

This goes in C1:

=B1+(ROW(B1)-1)*7

You'll have to change the 1 to whatever if you're gonna start from later rows.

 

[Matty]

Thanks Andrew and dafan.

Matty