Need variable that refers to same row different column

[Toddomation]

Background.:
I came up with this for a coworker->

Plug this formula into your B Column on the sheet of your report.

Formula:

=DATEVALUE(GXX)

where XX is the corresponding row value in column G


It would have been a lot cooler to send him a formula that he didn't have to
change.

Question.:
Is there a variable I can use in Excel that refers to the same row as the
selected cell, something like "=DATEVALUE(Gsamerow)" ???

TIA

 

[David Biddulph]

=DATEVALUE(INDEX(G:G,ROW())) is one option.

 

[מיכ×ל (מיקי) ×בידן]

I'm not sure I followed you - but you may check the INDIRECT Function.
=INDIRECT("G"&ROW())
Micky

 

[מיכ×ל (מיקי) ×בידן]

I assume you understood my suggestion - in any case the full formula is:
=DATEVALUE(INDIRECT("G"&ROW()))
Micky