software

I have two cells with two dates one is subtracting one from the other to give
time remaining but after the ewuation I would life the result plus text.

Example I want the cell to day 7 DAys

=(F13-E13),Text
Thanks
Joel

--
N/A

=(F13-E13)amp;quot; Daysquot;

--
Kind regards,

Niek Otten

quot;Joelquot; gt; wrote in message
...
gt;I have two cells with two dates one is subtracting one from the other to
gt;give
gt; time remaining but after the ewuation I would life the result plus text.
gt;
gt; Example I want the cell to day 7 DAys
gt;
gt; =(F13-E13),Text
gt; Thanks
gt; Joel
gt;
gt; --
gt; N/A
=(F13-E13)amp;quot; Daysquot;

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;Joelquot; gt; wrote in message
...
gt; I have two cells with two dates one is subtracting one from the other to
give
gt; time remaining but after the ewuation I would life the result plus text.
gt;
gt; Example I want the cell to day 7 DAys
gt;
gt; =(F13-E13),Text
gt; Thanks
gt; Joel
gt;
gt; --
gt; N/A

--
Kevin Backmann

=(F13-E13)amp;quot;Insert your text here, between the quotes.quot;

quot;Joelquot; wrote:

gt; I have two cells with two dates one is subtracting one from the other to give
gt; time remaining but after the ewuation I would life the result plus text.
gt;
gt; Example I want the cell to day 7 DAys
gt;
gt; =(F13-E13),Text
gt; Thanks
gt; Joel
gt;
gt; --
gt; N/A

=(f13-e13) amp; quot; Daysquot;

quot;Joelquot; wrote:

gt; I have two cells with two dates one is subtracting one from the other to give
gt; time remaining but after the ewuation I would life the result plus text.
gt;
gt; Example I want the cell to day 7 DAys
gt;
gt; =(F13-E13),Text
gt; Thanks
gt; Joel
gt;
gt; --
gt; N/A

Try this:

=F13-E13amp;IF(F13-E13gt;1,quot; Daysquot;,quot; Dayquot;)

Hope this helps!
Jean-Guy

quot;Joelquot; wrote:

gt; I have two cells with two dates one is subtracting one from the other to give
gt; time remaining but after the ewuation I would life the result plus text.
gt;
gt; Example I want the cell to day 7 DAys
gt;
gt; =(F13-E13),Text
gt; Thanks
gt; Joel
gt;
gt; --
gt; N/A