Hi
use:
=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"
Print Date: "&TEXT(TODAY(),"MM/DD/YY")

--
Regards
Frank Kabel
Frankfurt, Germany

Craig Petersen via OfficeKB.com wrote:
The date is comming out wrong

name.xls Print Date: 38351

I want


name.xls Print Date: 12/30/04


=MID(CELL("filename"),SEARCH("[",CELL("filename"))+1,SEARCH("]",CELL("filename"))-SEARCH("[",CELL("filename"))-1)&"
Print Date: "&TODAY()


Thank you for any help you can give
Craig Petersen