View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default 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.