I can't figure out how to read a date in a formula. In my column I have the
format set as mm/dd/yy, but the formula is looking at MMM and it is not
converting.

I want to add sums of money based on month, not mm/dd/yy and I think that is
where I'm faultering.

Here are details:

cell d1 = May
col c = dates (ie, 05/03/06)
col u = amounts

I want to add all the amounts that fell during the month of
May. How do I write this? THanks!