Weeks and dates

[c991257]

Hi.

I'm trying to do a spread sheet with a timeline based on weeks.

In the excel sheet attached I have tried to show what I want. How do I
get excel to do row 1?




+-------------------------------------------------------------------+
|Filename: Book1.txt |
|Download: http://www.excelforum.com/attachment.php?postid=5068 |
+-------------------------------------------------------------------+

 

[c991257]

I solved it by using the date instead and using the following:

=IF((TEXT(C2,"mmm"))=(TEXT(C2+6,"mmm")),(TEXT(C2,"mmm")),CONCATENATE((TEXT(C2,"mmm")),"/",(TEXT(C2+6,"mmm"))))

/Møller