I haven’t found a way to do calculations on a cell that contains both text and numeric information.
Here is how we handle this:
Using the “Convert Text to Columns Wizard”, split the data into two columns, defining 01/03/09 as a date. You are then able to perform any calculations necessary.
Sorry I couldn’t be more help.
If the date is always the right most 8 characters (02/05/09) or similar, you can use this formula to get the date value and then add 30 to it:
where A1 contents is:
A2 (format as appropriate date) contents would be:
The result should be 03/07/09