You did it again Biff, you always manage to find a way.

My next question is this, now I have the 15th of the month, what if I
want to number every day of the month like that. I know that I only
have 7 if function's available, so should I use my OR function as
well?

Or is this impossible?

Thanks

On Feb 21, 12:47 pm, "T. Valko" wrote:
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)- Hide quoted text -

- Show quoted text -