Weeks and dates

  • Thread starter Thread starter c991257
  • Start date Start date
C

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?

:confused:


+-------------------------------------------------------------------+
|Filename: Book1.txt |
|Download: http://www.excelforum.com/attachment.php?postid=5068 |
+-------------------------------------------------------------------+
 
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
 
Back
Top