Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct"

O

Orcababe

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?
 
S

Stefi

=TEXT(DATE(2009,1,1)+WEEKDAY(DATE(2009,1,1),2)+(A1-1)*7-7,"dddd dd mmmm")&" -
"&TEXT(DATE(2009,1,1)+WEEKDAY(DATE(2009,1,1),2)+(A1-1)*7-1,"dddd dd mmmm")
Regards,
Stefi

„Orcababe†ezt írta:
 
J

joel

=TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),2)+1+(A1*7),"DDDD
dd -
")&TEXT(DATE(YEAR(TODAY()),1,1)-WEEKDAY(DATE(YEAR(TODAY()),1,1),2)+7+(A1*7),"DDDD dd MMM")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October 0
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October 4
Inverse to WEEKNUM 12
convert weekday date to the next sunday date 1
Convert date to week number 3
modify code to just insert Mon-Sat date and day for Given Week End 0
if date has Saturday or Sunday in it need to add 2 or 1 to date 2
When I convert a date to a weekday, Sunday becomes Thursday? 1

Top