Excel Column Difference

Count the number of columns between two Excel column letters.

Columns between (exclusive)
?
Columns including bounds
?

Example: from B to F → 4 columns between (5 inclusive)

Recent history

    How it works

    Exclusive difference is the gap between the two columns: B=2 and F=6, so |6−2| = 4. It is how many columns you move to get from one to the other, which is the offset OFFSET expects. Strictly speaking, three columns sit between them — C, D and E.

    Inclusive count counts both endpoints: B, C, D, E, F = 5 columns. This corresponds to the width of the range B:F in Excel.

    This is useful when using the OFFSET function, building dynamic ranges, or calculating column widths in VBA.