Delete columns

Good morning, I do not know how to do it so that when the column is called MONTH it erases it completely, if the column or has any data, also it must erase it, if the column has zeros in all the cells also erase it. Should be deleted by those criteria since they are not always in the same column. Thank you.

Maybe:

Please Login or Register  to view this content.

Thank you very much, the two work perfectly. One last question if you would like before deleting a cell to change its name, cell A1, instead of DAY, put DAYS. What change would I have to make? Thank you.

I have already solved. Thanks for your help. regards

You're welcome. Glad to help out.