Thread: [Solved] Date diff in excel 2007
View Single Post
 
Old 04-13-2017, 09:04 AM
otuatail otuatail is offline Windows 7 64bit Office 2007
Competent Performer
 
Join Date: Jun 2012
Posts: 245
otuatail is on a distinguished road
Default

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
Reply With Quote