Does anyone know why when I use the equal (=) sign to get data from another
cell in another worksheet it just gives me the cell name: i.e. =targetdateC2.
and not the actual data which is 2x. I tried manually calculating to no
extent.

Thanks
Frank