I don't know if this possible, but looking for some help if it is. I am
guessing it would be with some sort of IF worksheet function.

I have a column of dates. In a separate cell a few columns to the right I
would like to enter a value (32.50) if the first of the month is among the
original column of dates; if not I would like to enter 0. I am guessing the
formula might look something like this:
=IF(11-01-06 is within the range D5:D18,32.50,0)

Again, any help with this would be appreciated, thank you.