Thread: Weeks and dates
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
c991257 c991257 is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote