software

I've always been doing formatting as =CONCATENATE(A4,quot; - quot;,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,quot;m/d/yyyyquot;),quot; - quot;,TEXT(B4,quot;m/d/yyyyquot;))
--
Gary's Studentquot;Joseph Zuraski IIquot; wrote:

gt; I've always been doing formatting as =CONCATENATE(A4,quot; - quot;,B4) where value is
gt; '12/20/2006 on A4 and '12/31/2006 on B4 (12/20/2006 - 12/31/2006 printed
gt; format).
gt;
gt; Without the ' on the formula it becomes numerical (39071 - 39082). Is there
gt; a way to make it read (12/20/2006 - 12/31/2006) without the ' symbols?
gt;
gt; Thanks,
gt;
gt; Joseph Zuraski II


Joseph,

=CONCATENATE(TEXT(A4,quot;mm/dd/yyyyquot;),quot; - quot;,TEXT(B4,quot;mm/dd/yyyyquot;))

Cheers,

Steve--
SteveG
------------------------------------------------------------------------
SteveG's Profile: www.excelforum.com/member.php...foamp;userid=7571
View this thread: www.excelforum.com/showthread...hreadid=509429=TEXT(A1,quot;mm/dd/yyyyquot;)amp;quot; - quot;amp;TEXT(B1,quot;mm/dd/yyyyquot;)

Vaya con Dios,
Chuck, CABGx3
quot;Joseph Zuraski IIquot; wrote:

gt; I've always been doing formatting as =CONCATENATE(A4,quot; - quot;,B4) where value is
gt; '12/20/2006 on A4 and '12/31/2006 on B4 (12/20/2006 - 12/31/2006 printed
gt; format).
gt;
gt; Without the ' on the formula it becomes numerical (39071 - 39082). Is there
gt; a way to make it read (12/20/2006 - 12/31/2006) without the ' symbols?
gt;
gt; Thanks,
gt;
gt; 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() gt; A1 and today() lt; A2 then display A2.
I've experimented with various functions and either get ?rue??or something
else.
Can you help?

Thanks

Hi Trackeous,

Try This in A3
=IF(AND(A1lt;TODAY(),TODAY()lt;A2),A2,quot;quot;)

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

HTH
Martin
=IF(AND(TODAY()gt;A1,TODAY()lt;A2),A2,quot;quot;)
--
David Biddulph

quot;Trackeousquot; gt; wrote in message
...
gt; Sorry about replying to your email to ask a question, but the system won't
gt; allow me to post a question - it just acts like I didn't press any
gt; buttons.
gt; What I am looking for is:
gt; 1. have Excel look at the Date in Cell A1,
gt; 2. have Excel look at the Date in Cell A2,
gt; 3. if today() gt; A1 and today() lt; A2 then display A2.
gt; I've experimented with various functions and either get quot;Truequot; or
gt; something
gt; else.
gt; Can you help?
gt;
gt; Thanks
Same stuff, another whey.............

=IF(TODAY()gt;A1,IF(TODAY()lt;A2,A2,quot;quot;),quot;quot;)

Vaya con Dios,
Chuck, CABGx3quot;Trackeousquot; gt; wrote in message
...
gt; Sorry about replying to your email to ask a question, but the system won't
gt; allow me to post a question - it just acts like I didn't press any
buttons.
gt; What I am looking for is:
gt; 1. have Excel look at the Date in Cell A1,
gt; 2. have Excel look at the Date in Cell A2,
gt; 3. if today() gt; A1 and today() lt; A2 then display A2.
gt; I've experimented with various functions and either get quot;Truequot; or
something
gt; else.
gt; Can you help?
gt;
gt; Thanks
Just wanted to thank you for your help. Your formula worked. I appreciate it.

quot;MartinWquot; wrote:

gt; Hi Trackeous,
gt;
gt; Try This in A3
gt; =IF(AND(A1lt;TODAY(),TODAY()lt;A2),A2,quot;quot;)
gt;
gt; You didn't say what you wanted if the answer is false
gt; so I put in a blank. Change the quot;quot; to whatever you like.
gt;
gt; HTH
gt; Martin
gt;
gt;
gt;

Your Welcome :-)