IF worksheet function

[Guest]

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 D518,32.50,0)

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

 

[Biff]

Hi!

Try this:

=IF(COUNTIF(D518,"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(D518,DATE(YEAR(TODAY()),MONTH(TODAY()),1)),32.5,0)

Biff

 

[Guest]

Biff,
Awesome! Thank you very much; it worked like a charm.

 

[Biff]

You're welcome. Thanks for the feedback!

Biff

Biff,
Awesome! Thank you very much; it worked like a charm.