Yes, you can use wildcards for dates in Excel. However, the syntax is a bit different than what you have tried.

To pick out all the dates in September 2008 from a column of many dates, you can use the following formula:

This formula uses

1. two SUMIF functions.
2. The first SUMIF function sums all the values in the range F7:F8 where the corresponding date in the range G7:G8 is greater than or equal to September 1st, 2008.
3. The second SUMIF function subtracts all the values in the range F7:F8 where the corresponding date in the range G7:G8 is greater than October 1st, 2008.
4. The result is the sum of all the values in the range F7:F8 where the corresponding date in the range G7:G8 is in September 2008.

Note that the dates in the range G7:G8 must be in a date format recognized by Excel. If they are not, you may need to convert them using the function or by changing the cell format to a date format.