Thread: Should be easy
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michell Major Michell Major is offline
external usenet poster
  
Posts: 34
Default Should be easy
=IF(AND(A4="4/12/2006",A4<="9/12/2006"),"49")

This should show next week as 'Week 49' but doesn't. I want to add another
three IF to this string so that I can get the month sorted out in Week order?
Reply With QuoteReply With Quote