Gives the number of current column or of the reference mentioned

Syntax of Excel Column formula:

In words:
=What is the column number(of this cell reference)


[reference] argument is optional. If left out then function will give the column number of current column where formula is inserted. If mentioned then it will give the column number of the referred cell.

Examples of Excel Column Formula

=COLUMN(HS76) will give 227
=COLUMN(A1) will give 1
=COLUMN(A1)-1 will give 0