Count Column Difference

[Raj]

Is there a function which could give me difference

e.g. if I am in cell G5, is there a function which would return me the
count it is away from say D5 such as

function (G55) = 3 (the column G is 3 cell away from column D)

alternatively if there is a function which could return the current
column (in number G5->7, D5->4) !!

Thanks for your help!

Kind regards,
Raj

 

[Guest]

Column difference:
=COLUMN(G5)-COLUMN(D5)

Current Column Number:
=COLUMN(G5)
=COLUMN(D5)

*** Please do rate ***

 

[Guest]

alternatively if there is a function which could return the current
In any cell:
=COLUMN()
will return the col # of that cell

---