I see a solution for this question using visual basic, however I am looking to use it in an Excel function. In the example attached I want to sum a range of values if the date is between two other dates.
I know I can sum if the date is greater or less than a specified date:
2:C$4) where the criteria is the Excel date as a serial number (in this case, before 1/1/09).
How can I do this if I want to sumif the date is between two dates? I tried this:
4) where the criteria is supposed to be any date in 2008.
I get a result of 0.
Also, I want to reference cells containing the date, not the Excel date serial value. See the attached example.