Hi,

The only reason I can think of that your formula does not work is if the
entries in B2 or G6 are not really dates either because there is extra spaces
or because they are not in a legal date syntax. In this case I would expect
a VALUE error. And you would get that even if you didn't have the text
added.

To deal with leading or trailing spaces try the following formula:
=TRIM(F10)-TRIM(E10)&" days to go"

To deal with illegal syntax enter the two date in m/d/yy order. For
example, Oct-20-2008 is an illegal syntax but it will display in the cell in
a way that you might think it's a date. Retype the dates as I suggested.

--
Thanks,
Shane Devenshire


"Peter" wrote:

I can add text to a number ok; that's straightforward, but I cannot add text
to formula. Eg. =B2-G6&" text". I am trying to have an ongoing formula
subtracting one date from another and tag "days to go" at the end. I thought
I would have found this in the help section easily enough but nooo...
Any advice anyone?
P