Using Excel 2003: Adding days to a cell that contains both a text and numeric entry.

5 pts.
Tags:
Microsoft Excel
Microsoft Excel 2003
Microsoft Excel formatting
Microsoft Excel formulas
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.

Answer Wiki

Thanks. We'll let you know when a new response is added.

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

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following