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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks