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

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"))
--
Gary's Student


"Joseph Zuraski II" wrote:

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

Joseph,

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

Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=509429

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

Vaya con Dios,
Chuck, CABGx3



"Joseph Zuraski II" wrote:

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

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

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

=IF(AND(TODAY()A1,TODAY()<A2),A2,"")
--
David Biddulph

"Trackeous" wrote in message
...
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

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

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

Vaya con Dios,
Chuck, CABGx3


"Trackeous" wrote in message
...
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

Just wanted to thank you for your help. Your formula worked. I appreciate it.

"MartinW" wrote:

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

Your Welcome :-)