| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October
1. "Get text string on basis of date":
In cell A1 I have a date with format "dd/mm/yyyy" (for example "27/10/2004"). Now I want to get in cell B1 a text string telling me the week that date falls into (for example "Monday 25th - Sunday 31st October"). What function do I have to use in cell B2 to get this text string? 2. "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? TIA Martin |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st Oct" | Excel Discussion (Misc queries) | |||
| Convert WEEKNUM(date;2) to text "Monday 25th - Sunday 31st October | Excel Programming | |||
| Formula to Indicate name of day (Sunday, Monday etc..) based on a Date | Excel Discussion (Misc queries) | |||
| Find the date for monday prior to May 25th | Excel Worksheet Functions | |||
| adding day (sunday, Monday) to date | Excel Worksheet Functions | |||
![Martin Los[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
