| 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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Entry in 1 Cell with result populating for entire week in ano
hi Mike
="week of: "&text(b2,"mm/dd/yy")&" - "&text(c2,"mm/dd/yy") hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Mike" escreveu: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Entry in 1 Cell with result populating for entire week in ano
Try this
="Week of: "&TEXT(B2,"mm/dd/yy")&"-"&TEXT(C2,"mm/dd/yy") or ="Week of: "&TEXT(B2,"mmmm d, yyyy")&"-"&TEXT(C2,"mmmm d, yyyy") "Mike" wrote: 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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date Entry in 1 Cell with result populating for entire week in
Thank you very much, it worked
"Mike" wrote: Try this ="Week of: "&TEXT(B2,"mm/dd/yy")&"-"&TEXT(C2,"mm/dd/yy") or ="Week of: "&TEXT(B2,"mmmm d, yyyy")&"-"&TEXT(C2,"mmmm d, yyyy") "Mike" wrote: 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. |
| Reply |
| 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) | |||
Linear Mode
