|
|
#5
04-13-2017, 09:04 AM
|
|||
|
|||
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 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel pivot table with a DATE value field for some reason stops at a certain date | angie450 | Excel Programming | 2 | 08-19-2014 08:50 AM |
| Letter date changes when merging with Excel - not the format, the actual date! | Smallweed | Mail Merge | 1 | 02-07-2014 06:00 PM |
 Date problem in excel 2007
|
msheyworth | Excel | 2 | 06-12-2012 05:10 AM |
|
range.insertfile produces diff result between word 2010 and 2007
|
rsmedley | Word | 1 | 02-15-2012 10:48 PM |
| Colorised diff add-on? | liamf | Outlook | 0 | 12-15-2010 08:02 AM |
Windows 7 64bit 
Office 2007
Threaded Mode