Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract two dates (decrementing daily) and add text
The formula you have is correct. What is your problem? What do you have in
B2 and in C6? What result did you get? What result did you expect? -- David Biddulph "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract two dates (decrementing daily) and add text
What are you getting? It works for me. Is this the only formula? Or is this
formula to be copied down or to the right, etc.? -- ** John C ** "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract two dates (decrementing daily) and add text
It works for me as well.
Another option would be to format the cell with the custom format: 0 " Days To Go" |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract two dates (decrementing daily) and add text
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Subtract if dates in the range between 2 dates. | Excel Worksheet Functions | |||
How to subtract 2 dates to get number of days.....please | Excel Worksheet Functions | |||
add/subtract dates problem in Excel..... | Excel Discussion (Misc queries) | |||
Subtract two dates | Excel Discussion (Misc queries) | |||
Subtract time and dates with restrictions | Excel Worksheet Functions |