You can put the date into a cell (might have to format the cell as text first) and then use the Indirect function: =SUM(Indirect("'C:\doc...\"&A1&"\["&A2&".xls]... where A1 has the month and A2 has the date.