Date Dilemma

[Raj1313]

Hi I have the below:

I want to put a formula in Column C and drag down without typing this manually can this be done? goes down to 52 weeks.

02/01/2017	Week 1	02/01 - 06/01
09/01/2017	Week 2	09/01 - 13/01
16/01/2017	Week 3	16/01 - 20/01

<tbody>
</tbody>

 

[FormR]

Hi, something like this maybe:

Excel 2013
	A	B	C
2	02/01/2017	Week 1	02/01 - 06/01
3	09/01/2017	Week 2	09/01 - 13/01
4	16/01/2017	Week 3	16/01 - 20/01
Sheet1

Cell Formulas
Range	Formula
C2	=TEXT(A2,"dd\/mm - ")&TEXT(A2+4,"dd\/mm")

 

[Raj1313]

Thanks mate!! works perfect