Simple question for those who know the answer. *Smiles*

  • Thread starter Thread starter chrisn
  • Start date Start date
C

chrisn

I think this is a pretty simple one, just need the "formatting tip".

Column A Column B Column C
03/22/2004 03/29/2004 =concatenate("Week of ",a1,"-",b1)

Obviously my equation is not working as Concatenate yields a "text
result and even pre/post formatting column c does not change it to dat
format.

Is there a way which I can concatenate two dates together in thi
fashion?

Chri
 
one way:

C1: ="Week of " & TEXT(A1,"mm/dd/yyyy") & "-" & TEXT(B1,"mm/dd/yy")
 
Not so simple, because we have to do it the hard way (grin).

=CONCATENATE("Week o
",DAY(A1),"/",MONTH(A1),"/",YEAR(A1),"-",DAY(B1),"/",MONTH(B1),"/",YEAR(B1)
 
Another option might be to include the dash in the first formatting.

=TEXT(A1,"mm/dd/yyyy - ") & TEXT(B1,"mm/dd/yyyy")

Another option might be to use a custom format.

"Week of: "@
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to calculate lead time excluding Friday and Saturday 3
Help With A Formula - Easy For Those Who Know 0
Logic to check a range for an existing sequence? 4
Macro Optimization - 25,000+ Rows 19
Game freezes system - possible ATI issue? 5
A simple menues question , but no on I've asked knows the answer 1
David Biddulph is correct 8
Held with YTD formula 1

Back
Top