Weeks and dates
 

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 |
+-------------------------------------------------------------------+

--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=563706

Weeks and dates
 

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


--
c991257
------------------------------------------------------------------------
c991257's Profile: http://www.excelforum.com/member.php...o&userid=36549
View this thread: http://www.excelforum.com/showthread...hreadid=563706