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:
Formula:
=SUMIF(G7:G8,"=01/09/2008",F7:F8)-SUMIF(G7:G8,"01/10/2008",F7:F8)
This formula uses
- two SUMIF functions.
- 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.
- 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.
- 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.