Combine date (month) and text and still be able to add a month to next column

[kinscy]

I have searched everywhere for this and I can't seem to find it, maybe there is a better way to explain what I need??

Does anyone know if there is a way to combine a date with text and still be able to add a month so the spreadsheet updates itself if you change one of the dates?

For example, lets say you had a spreadsheet with the following columns:

Jan Sales
Feb Sales
Mar Sales
And so on until December

Is there a formula that I can use so that if the first one changes from Jan Sales to say Apr, the rest of the dates in each column will update automatically?

[FDibbins]

If the dates really are dates, and not text that looks like a date (test with =isnumber()...FALSE = text), there are quire a few ways to do what (I think) you want to do. Assuming you have your dates starting in A2 down...

In A3, copied down
=edate(A2,1)
or
=Date(Year(A2),MONTH(A2)+1,Day(A2))

It w0iuld be easier to offer more specific suggestions if you provided a sample workbook

[kinscy]

Thanks for the help, I managed to get this done a completely unexpected way but I will post the answer just in case anyone else finds it useful as I searched for HOURS!!

What I did was create a custom format and added it to all the column headers, in the custom format field I typed MMM "Sales".
Then in the first column I typed a date, then in the second column I used the formula =DATE(YEAR(C1),MONTH(C1)+1,DAY(C1)) and dragged it to the end.

[FDibbins]

Good solution, and thanks for sharing it with us