No you are missing the point.
Cell B2 has the date Value "25/03/2017 11:30:00"
Cell B8 has the date value "31/03/2017 12:00:00"
NOW
I am going to but into cell E2 the text value 'B2'
I am going to but into cell F2 the text value 'B8'
What I want to put into cell G2 is a calculation which requires it to LOOK at Cell E2 find the contents of that cell and look at as a pointer to the cell containing the date.
Cell E2 and F2 don't have a date value just the pointer to the cell that has the date. It is a reference/pointer
|