Greetings All - I have a spreadsheet which I'm needing to list all "ID #'s" (column A) if the "Date Created" (column J) was during a specific month. The cell where the month will be typed is M2. The values in "Date Created" is formatted as m/d/yyyy h:mm. I'm aware a pivot table could do this, but I'm needing the formulas to list the ID #'s the long way. Thanks in advance for your help.