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?

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

=TEXT(A2-WEEKDAY(A2,2)+1,"dddd d - ")&TEXT(A2-WEEKDAY(A2,2)+7,"dddd d
mmmm")

--
__________________________________
HTH

Bob

"Orcababe" wrote in message
...
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?

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

=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)+(A 1-1)*7-1,"dddd dd mmmm")
Regards,
Stefi

€žOrcababe€� ezt Ã*rta:

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?

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

=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")

"Orcababe" wrote:

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?