View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peter Peter is offline
external usenet poster
 
Posts: 349
Default Subtract two dates (decrementing daily) and add text

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