Hi all,
I am trying to find a solution about a logical table. let me explain you:
In Column A I have numbers form 1 up to 5, in columnn B I want to receive the date week by week, what I mean:
1 01.01.2013 to 06.01.2013
2 07.01.2013 to 13.01.2013
..and so and so week by week
This is what I did till now:
A B
1 =TEXT(DATE(2013;1;1);"dd/mm/yyyy")&" to "&TEXT(DATE(2013;1;1);"dd/mm/yyyy")
2 = ? (should be: =TEXT(DATE(2013;1;1)+6 & TEXT(DATE(2013;1;1);"dd/mm/yyyy")+7
Is it possible to do this without this SUM(7 and 6)? I want to be automatic, when I drag the formula from B1 to B5 to have the result that I want?
See enclosed file
Thank you in advance!
Example.xlsx
Bookmarks