CODE EXAMPLE FOR EXCEL

excel number of column

=COLUMN(A1)

The COLUMN function returns the column number of the given cell reference.
=COLUMN(D10) returns 4 because column D is the fourth column.