Text after ewuations

[Joel]

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

[Niek Otten]

=(F13-E13)&" Days"

--
Kind regards,

Niek Otten

"Joel" <[email protected]> wrote in message
news:[email protected]...
>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

[Bob Phillips]

=(F13-E13)&" Days"

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Joel" <[email protected]> wrote in message
news:[email protected]...
> 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

[Kevin B]

--
Kevin Backmann

=(F13-E13)&"Insert your text here, between the quotes."

"Joel" wrote:

> 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

[bpeltzer]

=(f13-e13) & " Days"

"Joel" wrote:

> 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

[pinmaster]

Try this:

=F13-E13&IF(F13-E13>1," Days"," Day")

Hope this helps!
Jean-Guy

"Joel" wrote:

> 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