Column Calculation

[insomniac53]

It's early morning here and brain not in gear.
In Excel, I need a formula to generate an integer depending upon the column number.
Starting at column 3, the integers are simply 1,2,3.

Column 3 : Integer 1
Column 5 : Integer 2
Column 7 : Integer 3

and so on. I'll be embarrassed when I see it, but what is the formula to generate these integers from their column positions. Excel rather than VBA, if possible. Thank you.

 

[Legacy 143009]

=COLUMN()-2

Is that all?

 

[AlanY]

try

=(COLUMN(C1)-COLUMN($A$1))/2

 

[insomniac53]

Thanks for both replies.
I used:

=ROUNDDOWN(COLUMN() / 2,0)