CONCATENATE And Date Format

  • Thread starter Joseph Zuraski II
  • Start date
J

Joseph Zuraski II

I've always been doing formatting as =CONCATENATE(A4," - ",B4) where value is
'12/20/2006 on A4 and '12/31/2006 on B4 (12/20/2006 - 12/31/2006 printed
format).

Without the ' on the formula it becomes numerical (39071 - 39082). Is there
a way to make it read (12/20/2006 - 12/31/2006) without the ' symbols?

Thanks,

Joseph Zuraski II
 
G

Gary''s Student

By using a single quote (apostrophe), you are forcing a string rather than a
real date.


If you want to omit the single quote, then use the TEXT() function:

=CONCATENATE(TEXT(A4,"m/d/yyyy")," - ",TEXT(B4,"m/d/yyyy"))
 
S

SteveG

Joseph,

=CONCATENATE(TEXT(A4,"mm/dd/yyyy")," - ",TEXT(B4,"mm/dd/yyyy"))

Cheers,

Steve
 
T

Trackeous

Sorry about replying to your email to ask a question, but the system won't
allow me to post a question - it just acts like I didn't press any buttons.
What I am looking for is:
1. have Excel look at the Date in Cell A1,
2. have Excel look at the Date in Cell A2,
3. if today() > A1 and today() < A2 then display A2.
I've experimented with various functions and either get “True†or something
else.
Can you help?

Thanks
 
M

MartinW

Hi Trackeous,

Try This in A3
=IF(AND(A1<TODAY(),TODAY()<A2),A2,"")

You didn't say what you wanted if the answer is false
so I put in a blank. Change the "" to whatever you like.

HTH
Martin
 
C

CLR

Same stuff, another whey.............

=IF(TODAY()>A1,IF(TODAY()<A2,A2,""),"")

Vaya con Dios,
Chuck, CABGx3
 
Top