Date Formula
 

I am trying to have the date from one workbook populate into another
workbook. When I just enter the formula to simply copy the cell (= cell), it
is either not giving me a date at all or it is coming up January 0, 00. I
have no problem with this formula for other types of text or data, but the
date is not working. Any suggestions? I've tried different cell formats,
but that doesn't seem to work either.

Thanks!