Inserting date by referencing date cell into a formula

[LikeButtah]

I would like to use the dates listed in a column and insert them into a formula
(ie. =INDIRECT.EXT("'O:\Payroll & Rollcall\[7-3-11xls.xls]Summary'!M9"). The problem I think is in the syntax of the date since I’m using the minus or dash because the look of the date in the cell is 7-3-11 but in the formula bar when you click on the date it shows it as 7/3/11. Is there a way of inserting the date by referencing the date cell in the formula? And if so is the workbook name "7-3-11xls.xls" a problem? Thanks.

 

[bensonsearch]

the workbook name will be a violation and cause it not to work. is it a separate workbook you are referancing?

 

[bebo021999]

Try this formula like this:
=CELL("filename",'7-3-2011'!A1)
will return full path like this:
C:\Documents and Settings\TheQuang\Desktop\[Book2.xls]7-3-2011
Next, use text function to separate date: TEXT("string","dd/mm/yyyy")