The COLUMN function returns the column number against the given cell reference. For example, =COLUMN(B1) returns 2 which means B column is the 2nd column.
The COLUMN function has the following argument:
[reference] – Optional. The cell reference or a range of cell against which Excel returns the column number. If omitted, Excel assumes the reference of the cell where the function appears.
Note: When a range of horizontal cells is selected e.g. (E6:G7), Excel returns the number of the leftmost column.
For more examples and detail, visit Microsoft Office website.
ROWS function returns the number of columns in a reference or an array.
COLUMNS function uses to find out the number of columns in a selected array or reference.