Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel forumula to add a month
Name: blah020122 Date: January 28, 2007 at 15:28:45 Pacific OS: OS X CPU/Ram: Intel Core Duo 1.5 GB Product: Apple Mac Mini
Comment:
There is a thread in this forum describing how to add 30 days to a month in Excel. It is pretty easy. (If the date is in A1, then "=A1+30" is 30 days later.)
What if, instead of adding 30 days, I want to add one month? I haven't been able to figure out how to do that.
Name: Bryco Date: January 29, 2007 at 03:26:15 Pacific
Reply:
Not sure of how you would apply such a formula but I also do not see how Excel could know which month you want to add.
Similarly the months, by name, are simply text so: 1/1/07+February=? Apple+Table=?
Excel, being a calculator, can only calculate numbers and not text.
Perhaps, if you could explain what you are wanting to do with this then perhaps an answer/solution could be presented.
Bryan
0
Response Number 2
Name: Michael J (by mjdamato) Date: January 29, 2007 at 11:03:00 Pacific
Reply:
You will need to break the date down to its parts (day, month, year). Then add 1 to the month value and then recreate the date using the new parts. If the month is december (12) and you add 1 to it (13), Excel will handle it correctly and jump to the next year.
Assuming the cell A1 contains the data that you want to add 1 month to, the formula would be:
Summary: I have one cell (say A1) that is filled with a date...say January 9, 2006. I need a formula to add 30 days to that date and then populate a cell (say C3) with the correct result (in this case the valu...
Summary: I am using Excel 2007 and would like to add a button that when clicked will add a numeric value of 1 in a seperate field. The idea is if my kids are good, we can click the button to add a point and an...
Summary: I have a spreadsheet with a column of formulas. These formulas have some variations from row to row but they all end with "$9880". I want to add a relative reference "+e6" to these formulas. The tric...
0 
