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
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)&" 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
=(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 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
=(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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks