Try something like this:

If the date in cell A1 is the 15th of a month return 10, otherwise, leave
the cell blank.

=IF(DAY(A1)=15,10,"")

Biff

"Excel_Oz" wrote in message
oups.com...
Hi all,

Hoping that you can all put your heads together and help me on this
problem.

I want to create an IF function that will look up a column of DATES
and insert an amount in another column only where the date is (say)
the 15th of each month.

Is it possible? Has it been done before? Can someone help?

Thanks!! :o)