View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Text after ewuations

Try this:

=F13-E13&IF(F13-E131," 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