Thread: Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Orcababe Orcababe is offline
external usenet poster
  
Posts: 2
Default Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct"
How can I get text string on basis of weeknumber:
In cell A1 I have the number of a week (WEEKNUM(A1;2)). How can I get in B1
a text string telling me the week that date falls into (for example "Monday
25th - Sunday 31st October") using the value of the weeknumber in A1?

This would be WEEKNUM and not ISO week number as my weeks always end on a
Sunday.

Cany anyone help?

Reply With QuoteReply With Quote