Using a formula to fill in a sentence

**davidingilbert** · 08-05-2013, 04:44 PM

Hello.
I am attempting to develop a formula so that when I change the month in two other columns, it automatically changes it in a 3rd column.

The heading of the main column says "Average error rate for Feb to July".
Currently, at the start of every month, I need to manually go in and change that heading to the 6 month window corresponding to the month I am testing. (I am testing July Production, so the window is now Feb to July)
I am looking to see if there is a way that when I type the first month I need, then the last month I need, it will automatically change the months involved in the sentence "Average error rate for Feb to July" to whatever months I need.

Thanks.

**daffodil11** · 08-05-2013, 04:58 PM

Where A1 = month1, B1 = month 2

="Average error rate for "&A1&" to "&B1

**Pauleyb** · 08-05-2013, 04:59 PM

Assuming A1 has your first month and A2 your second month:
="Average error rate for "&A1&" to "&A2
This is assuming A1 and A2 are text, e.g. "July". If they are actual dates then you will need to use TEXT(A1,"mmm") in place of A1 and a similar change for A2.