| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how i convert "100" to "hundred"( number to text) in excel-2007 | Excel Worksheet Functions | |||
| function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
| Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho | Excel Discussion (Misc queries) | |||
| Why does excel convert my text "6990011011234" to "6.99E+12"? | Excel Discussion (Misc queries) | |||
| Find the date for monday prior to May 25th | Excel Worksheet Functions | |||
Linear Mode
