So you want a different value returned based on the day?

1/3/2007 = day 3

What do you want returned for day 3?

That would mean there are potentially 31 different values to return. If
that's the case then you'll need to create a lookup table. Or, if there's
some pattern to values returned we might be able to hack something together.

Biff

"Excel_Oz" wrote in message
ups.com...
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 -