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

"Toddomation" wrote in message
...
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