IF worksheet function

W

WOLLAM

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.
 
B

Biff

Hi!

Try this:

=IF(COUNTIF(D5:D18,"2006/11/1"),32.5,0)

Do want this specifically for Nov 1 2006 or do you want it for the CURRENT
month? If so:

=IF(COUNTIF(D5:D18,DATE(YEAR(TODAY()),MONTH(TODAY()),1)),32.5,0)

Biff
 
Top