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.

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.

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.

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.