Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.
Can a formula be written that allows days to be added to a cell that contains both text and numeric information? For example, Cell A1 has NAME 1/3/09. I want to add 30 day increments to the 1/3/09 date in adjacent cells. Can it be done? If so. how? Thanks.
Software/Hardware used:
Software/Hardware used:
ASKED:
February 5, 2009 7:37 PM
UPDATED:
February 5, 2009 8:43 PM
Answer Wiki:
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:
NAME 02/05/09
A2 (format as appropriate date) contents would be:
=datevalue(right(a1,8))+30
The result should be 03/07/09
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
