Forum Discussion
Date for all rows
Hello, I have a folder with multiple files, everyday there comes a new file in the folder. (it is a summary with all the production numbers each day). Each file contains the date of that day ...
Hi Anonymous ,
Can you include a screenshot of where your date cell is, and where your production data table starts?
Also, are the data on just one worksheet in your file?
m_dekorte I like your first method, but using the 'date created' from the Windows metadata works only if the file is created on Sjouke's folder on the same day as the production data refer to. This may not always be true, e.g., there could be a lag of a day. Probably Sjouke wants to extract the cell from Excel itself, ie., your second method.
The date is in the name and in a very random place at the bottom of the sheet. see the screenshots