Try

=COLUMN()-COLUMN($A$7)-1

If this post helps click Yes
---------------
Jacob Skaria


"pol" wrote:

Please help me to find out number of column occured between
activecell and A7

For example current column M7 . I want to find out the number of column
between
the column M7, A7

It would be very helpful to me please help

With thanks
Pol