View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_2_] Peo Sjoblom[_2_] is offline
external usenet poster
 
Posts: 964
Default Subtract two dates (decrementing daily) and add text

Works for me, what result did you get?

--


Regards,


Peo Sjoblom

"Peter" wrote in message
...
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