| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Entry in 1 Cell with result populating for entire week in ano
What I am trying to do is user types in date in 1 cell (say B2)i.e. 02/03/08
C2 populates with the date + 6 Then in A7 I would like it to take the date from Cell B2 and show up as 1 of 2 ways: either: Week of: 02/03/08 - 02/09/08 or Week of: February 3, 2008 - February 9, 2008 Everything I have tried gives me a result in numerals or a #value error ="Week of:"+B2&" - "&C2 - this results in the #value error =b2&" - "&c2 - this results in 39481 - 39487 I have formated all cells as Date as well. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populating Last Saved Date in Cell AND also update that same cell in Header | Excel Discussion (Misc queries) | |||
| Populating Multiple Worksheets with one entry | Excel Worksheet Functions | |||
| How do I get a cell to show the day of the week when date entered | Excel Discussion (Misc queries) | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
Threaded Mode
