Adding Columns in Excel with a Formula

[O_]

Hello All!

I am trying to make an "IF" statement that will automatically create a new column to the right.  The basis of the if is a change in the month.  So, I would like a new column to appear every month automatically.  Help!

[DataNath · Accepted solution]

Do you mean something like this? If not, provide a few extra details if possible and we can help get you to a solution! Workbook attached.

[O_]

Thanks!  I think that should do it!