How do I get data from a folder in Excel?

How do I extract data from a folder in Excel for Mac?

I have a folder in Excel for Mac that I want to extract information from.

This folder has a list of data separated by year, month, and day. It looks like this:

I need to take these three values (2019, May, 17) and turn them into an actual date value. I am using VBA in Excel for Mac because it's what I've been using before (and I know how to code). Try the following: Steps: 1) Extract the needed column/cells from the folder. 2) Place all the extracted data into variables: a) Month: eg 2023. B) Day: eg 17. C) Year: eg 2023. 3) Format the cell to Text: eg 'mm/dd/yyyy'. 4) Assign the formatted cell to a variable: eg NewDate. 5) Add the formatted date to your list. A = New Date(a). More details. A) See also How do I use variables as cells in a worksheet? and. B) The day is between 1 and 31. C) The month is between 1 and 12. D) You can use the function DateValue to convert any date to a date value.